Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “acquit” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

162 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
acquit1761032(None) 
acquits1857291acquits
acequia1844132acequia
acquaint1945722acquaint
acquest1837172acquest
acquire1835602acquire
acuity1139372ac_uity
asquint16208322asquint
quit136136512__quit
racquet1838742racquet
schuit1139562schuit
abduct11108543abduct
about75229083abou_t
abrupt1039943abrupt
abut66834953a_bu_t
acacia10311353acacia
acari75020283acari_
acarid95017073acarid
accent105116263accent
accept123210623accept
accost101112263accost
account11109043account
accurst1146243accurst
accuse103411033accuse
acedia9310393acedia
acequias1943973acequias
acetic10314503acetic
acetin8314693acetin
acid77533393ac__id
acidic113612133acidic
acidity1338593acidity
acini75718983acini_
acinic104713543acinic
acmic11312333ac_mic
aconite9315473aconite
acquaints2042993acquaints
acquests1944643acquests
acquired2044043acquired
acquiree1944603acquiree
acquirer1944093acquirer
acquires1945403acquires
acquittal2052123acquittal
acquitted2143503acquitted
acquitter2043553acquitter
acrid86920103ac_rid
act59557843ac___t
actin74922553ac_tin
actual8311023actual
actuate9311443actuate
acuate8315633ac_uate
acute74720363ac_ute
adduct1087373adduct
adit56443653a__dit
adjust1447183adjust
admit8319493a_dmit
adroit7518793adroit
adult63520653a_dult
adust64117453a_dust
afrit8323173a_frit
agouti7388773agouti
ait38093903a___it
albeit8314343albeit
aliquot1646493aliquot
alit46155693a__lit
ambit94223713a_mbit
amount8414483amount
annuity1045543annuity
aqua132813963a_qu_a
aquae142212713a_quae
aquas142412613a_quas
aquavit1945203a_quavit
armpit10811093armpit
attrit6315753attrit
audit62527883a_udit
august739203august
aunt46553653a__unt
avaunt959603avaunt
await85524493a_wait
backbit17129103backbit
backfit18108213backfit
backlit15911903backlit
banquet1839783banquet
bruit76126723_bruit
caput9823983capu_t
casuist9411303casuist
catsuit959393catsuit
chit96937463_c_hit
coquet174318013coquet
coquito1845403coquito
count74932053_count
court75532773_court
crit65743713_c_rit
cruet74831843_cruet
crust75827663_crust
cubit94122893_cubit
cuif96529143_c_uif
cult66541153_c_ult
cunt66243673_c_unt
curt67051713_c_urt
cut57957663_c_u_t
dacoit9415453dac_oit
diquat1639763diquat
duit56241583__duit
equid154610323_equid
equip16467263_equip
equity1838103_equity
faquir1834313faquir
fruit85122223_fruit
inquiet16311413inquiet
intuit6314083intuit
jesuit1339583jesuit
lacquer18135153lacquer
lacquey21143803lacquey
lawsuit1044953lawsuit
liquid1637143liquid
loquat1558283loquat
maqui16249953maqui_
maquis17249483maquis
marquis18247063marquis
mesquit18387953mesquit
mezquit27365113mezquit
occult1038433occult
parquet18311583parquet
pasquil1843923pasquil
picquet2047743picquet
piquet17412353piquet
qubit164218993__qubit
quid144922353__quid
quiet144530733__quiet
quilt144125103__quilt
quin135823923__quin
quint144529903__quint
quip154818623__quip
quirt144624233__quirt
quite144621463__quite
quits144122353__quits
quiz224920003__quiz
quoit143819863__quoit
racquets1944763racquets
recruit939773recruit
requin15310713requin
requite162012483requite
roquet154415893roquet
sacbut10811943sacbu_t
sacque17107113sacqu_e
sacques18106863sacques
schuits1235823schuits
scout75031453scou_t
scut65835543sc_u_t
sequin1538523sequin
squat143720143_squat
squib163710503_squib
squid154211903_squid
squint154214793_squint
squirt153812933_squirt
suit45649873__suit
tacit76333673tac__it
toquet154414683toquet
unquiet16310663unquiet
vacuity1545763vac_uity
yanqui1843383yanqui_
yanquis1943723yanquis

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.376475242.0
2DLD Change Limit1127161625.39020912.1
3Display Results1621620.0463521.7
 (SQL Overall)1786911625.81230745.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.