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 “wairs” 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.

240 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
wairs8642406(None) 
airs46447421_airs
fairs85825441fairs
hairs86225171hairs
lairs55425871lairs
mairs76228291mairs
pairs75325831pairs
vairs85019131vairs
waifs115719871waifs
wails86631481wails
wains86930861wains
wair75830051wair_
waits88333521waits
wars78659801wa_rs
weirs84316491weirs
whirs115218091whirs
aids57846352_aids
ails45654712_ails
aims67738182_aims
ains46158882_ains
air38058392_air_
airn46433832_airn
airns55521032_airns
airt45757782_airt
airts55626342_airts
airy75734152_airy
ais39083572_ai_s
aits46355532_aits
amirs75924912amirs
ars37670932_a_rs
awaits96411952awaits
bails75933522bails
bairn77515532bairn
bairns86710872bairns
baits76630582baits
bars66564092ba_rs
caids85226422caids
cains75334302cains
caird85717232caird
cairds96411512cairds
cairn75717512cairn
cairns85313302cairns
carrs75730852carrs
cars67364762ca_rs
chairs114916172chairs
coirs75221052coirs
dairy97016302dairy
dais57040702dai_s
deairs74013782deairs
ears46356592ea_rs
emirs76116152emirs
fails85631482fails
fair76332522fair_
fairy115318282fairy
fakirs13468082fakirs
faqirs18456032faqirs
fiars86720832fiars
firs76637712_firs
flairs95711912flairs
flirs85518932flirs
gains65729512gains
gaits65726012gaits
gars55750742ga_rs
gaurs66317992gaurs
glairs75211332glairs
haars85620472haars
haiks125120932haiks
hails85231642hails
hair76330142hair_
hairy115316832hairy
heirs85618562heirs
jails125422942jails
jars117338352ja_rs
kafirs13306982kafirs
kaifs125715642kaifs
kails95525212kails
kains96125642kains
keirs95313672keirs
kirs85831732_kirs
laics76419252laics
lair45934152lair_
laird65417792laird
lairds74711612lairds
laris54737462laris
lars46956572la_rs
liars54723162liars
maars74621632maars
maids86327132maids
mails76037772mails
maims96321782maims
mains75635092mains
mair66133762mair_
mars66261862ma_rs
mirs66940562_mirs
nadirs7109002nadirs
naifs87617422naifs
nails55730402nails
naira5314742naira
nairas6312772nairas
nairu5413812nairu
nairus639142nairus
naris55735292naris
noirs55615462noirs
oars46846032oa_rs
paiks114719852paiks
pails75833062pails
pains75138282pains
pair66031512pair_
paris75145942paris
parrs75928672parrs
pars67560792pa_rs
qaids156116312qaids
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622rai_s
sabirs85414622sabirs
saids65328852saids
sails55738102sails
sains55639972sains
saris54544952saris
sirs44338332_sirs
stairs65416332stairs
stirs55921612stirs
swails94913122swails
swains94513952swains
tahrs85412332tahrs
tails55634192tails
tains54936322tains
tapirs84113172tapirs
tars46763952ta_rs
twains95811182twains
vails85825932vails
vair75624142vair_
vars75742072va_rs
wabs97337232wa_bs
wacks146626282wacks
waders109120642waders
wades95634142wades
wadies105121202wadies
wadis95223962wadis
wads87343142wa_ds
waes76048602wa_es
wafers124316142wafers
waffs146315472waffs
wafts116920552wafts
wagers105122202wagers
wages95330932wages
wags86140552wa_gs
waif105836742wai_f
wail75238822wai_l
wailers103916802wailers
wain75840192wai_n
waired106015832waired
waist86132382waist
waists97415452waists
wait75553692wai_t
waiters104218622waiters
waive114214602waive
waivers133410052waivers
waives123714182waives
wakers134822492wakers
wakes126633652wakes
walers94824462walers
wales86142832wales
walies95324522walies
walks126218502walks
walls85529382walls
walrus956432walrus
wames106432802wames
wamus105514682wamus
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452262wa_ns
wants87932212wants
waps96642082wa_ps
war67262422wa_r_
ward86542252wa_rd
wards97734402wards
ware76254722wa_re
wares88250582wares
wark115737772wa_rk
warks127932402warks
warm95935672wa_rm
warms107726852warms
warn75239322wa_rn
warns87231002warns
warp95635002wa_rp
warps107126422warps
wart77866082wa_rt
warts814840402warts
wary106740012wa_ry
was68767562wa__s
wasps106714692wasps
wasts87433672wasts
waters95030622waters
wats77555882wa_ts
watts86923092watts
wauks125515162wauks
wauls86120552wauls
waur76819902waur_
wavers125022472wavers
waves115633922waves
wavies125019842wavies
wawls115416472wawls
waws106834902wa_ws
waxers164014302waxers
waxes155825502waxes
ways107737952wa_ys
wears86030302wears
weir76019922weir_
weird95111282weird
weirds10478052weirds
whids125413982whids
whigs125612642whigs
whims134515332whims
whins114922332whins
whips134917082whips
whir105519282whir_
whirl114913822whirl
whirls124710532whirls
whirr114611192whirr
whirrs12408592whirrs
whits115923822whits
wigs84931252w_igs
wins75949172w_ins
wire75839812w_ire
wires86034912w_ires
wiry106422832w_iry
wis66552332w_i_s
wiss75630542w_iss
wits76044872w_its
wries85827742wries
writs86624382writs
yaird96111912yaird
yairds10448022yairds
zaire14311992zaire
zaires1539702zaires

Search took 3 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.0802233637.5
2DLD Change Limit538002402.07625915.2
3Display Results2402400.0633809.5
 (SQL Overall)1786912402.21980527.7
 
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.