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 “airts” with Change Limit: [1] [2]

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

221 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
airts5562634(None) 
airns55521031airns
airs46447421air_s
airt45757781airt_
airth85621021airth
airths95414251airths
aits46355531ai_ts
arts49650261a_rts
dirts66824461dirts
girts65423621girts
abets75621672abets
aborts84916182aborts
abris75722602abris
abuts75417072abuts
acres76327762acres
acts66929862a_cts
adits66523712adits
afrits9311902afrits
agists75713172agists
aides65336602aides
aids57846352ai_ds
aigrets82810532aigrets
ails45654712ai_ls
aims67738182ai_ms
ains46158882ai_ns
air38058392air__
airbus848342airbus
aired66032922aired
airer54927892airer
airers64922312airers
airest63825262airest
airn46433832air_n
airted74214502airted
airy75734152air_y
ais39083572ai__s
ait38093902ai_t_
alerts64418222alerts
alts46639902a_lts
amirs75924912amir_s
ants47243472a_nts
aorta55922572aorta
aortas65417782aortas
apres75426402apres
arbs66834732a_rbs
arcs67834782a_rcs
ares45871022a_res
arfs76029962a_rfs
arias55438022arias
arils58732202arils
arks85936872a_rks
arms66137492a_rms
arras55626132arras
arris56824682arris
ars37670932a_r_s
art38679142a_rt_
artsy86012962a_rtsy
arty77531312a_rty
aunts55227632aunts
auras55932552auras
aures55137092aures
auris55331522auris
averts95715242averts
bairns86710872bairns
baits76630582bai_ts
bints76130182bints
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
birth105619872birth
births115713602births
bits66148152bi_ts
bitts75022592bitts
borts76735452borts
brits76433082brits
cairds96411512cairds
cairns85313302cairns
carts78946292carts
cires74932912cires
cists76624532cists
crits75527572crits
darts67635732darts
diets66026642diets
dints67431312dints
dirks105619522dirks
dirls64720502dirls
dirt55550382dirt_
dirty95617802dirty
dits56450522di_ts
faints94818782faints
fairs85825442fair_s
farts88336842farts
fiats85324482fiats
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
first86226122first
firsts95110922firsts
firth115819532firth
firths125113502firths
fists85527542fists
fits76043462fi_ts
flirts95411482flirts
forts86034452forts
frits86129102frits
gaits65726012gai_ts
gifts96214962gifts
gilts64924262gilts
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girt56646422girt_
girth95618842girth
girths105612272girths
gists66026192gists
gits55744592gi_ts
grits65529582grits
haints94417582haints
hairs86225172hair_s
harts88441592harts
hilts86924412hilts
hints87330622hints
hires86134342hires
hists86328372hists
hits75545132hi_ts
hurts86922822hurts
ires45639282_ires
iris45732542_iris
irks86220132_irks
its35538832_i_ts
jilts124717412jilts
karts97630112karts
kilts95122182kilts
kirks84915262kirks
kirns95315452kirns
kirs85831732kir_s
kists95822112kists
kits86441762ki_ts
lairds74711612lairds
lairs55425872lair_s
lifts85719062lifts
lilts55822802lilts
lints57137192lints
liras56021982liras
lists56628692lists
lits46252492li_ts
mairs76228292mair_s
maists85817572maists
marts77442232marts
milts75430712milts
mints76834042mints
mires75640882mires
mirks115122142mirks
mirs66940562mir_s
mirth106418892mirth
mirths114912992mirths
mists76633902mists
mitts75523752mitts
morts75533562morts
nairas6312772nairas
nairus639142nairus
nerts55924982nerts
nits45741642ni_ts
orts46538332_orts
paints85921832paints
pairs75325832pair_s
parts77743372parts
pints75936222pints
pirns76020092pirns
pits66348742pi_ts
ports75934592ports
quirts154213552quirts
rifts85718642rifts
riots54922012riots
saints65122422saints
shirts94918332shirts
sifts84918922sifts
silts55330822silts
sires55945372sires
sirs44338332sir_s
sits45050202si_ts
skirts104111502skirts
sorts54536662sorts
spirts85317132spirts
taints64520532taints
tarts57242022tarts
tilts55325612tilts
tints56030922tints
tires55437492tires
tirls54519802tirls
tiros54524892tiros
tits46145032ti_ts
torts56138122torts
vairs85019132vair_s
verts85724732verts
vires84529682vires
virls85618602virls
virtu85314092virtu
virtus94310142virtus
virus85316842virus
wairs86424062wair_s
waists97415452waists
waits88333522wai_ts
warts814840402warts
wilts85023502wilts
wires86034912wires
wists86728522wists
wits76044872wi_ts
worts88631182worts
writs86624382writs
yairds10448022yairds
yirds96612512yirds
yirrs8469192yirrs
yirth116513752yirth
yirths12639532yirths
yurts87216532yurts
zaires1539702zaires
zits136030292zi_ts

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002211.81329674.6
3Display Results2212210.0633507.9
 (SQL Overall)1786912211.96990752.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.