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

231 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
coirs7522105(None) 
choirs114911881choirs
coifs105718701coifs
coils75030081coils
coins75834551coins
coir66327241coir_
cors66656441co_rs
noirs55615461noirs
airs46447432_airs
amirs75924922amirs
boars75229602boars
boils75427192boils
boors74325012boors
caids85226432caids
cains75334302cains
caird85717232caird
cairds96411512cairds
cairn75717512cairn
cairns85313302cairns
carrs75730852carrs
cars67364762c_ars
ceils75019402ceils
chairs114916182chairs
chars105936642chars
chias104625522chias
chics123920942chics
chins105631462chins
chips125721252chips
chirk144516182chirk
chirks155414842chirks
chirm125317062chirm
chirms135113982chirms
chiro105320342chiro
chiros114617772chiros
chirp124717162chirp
chirps135414002chirps
chirr105015902chirr
chirrs114514982chirrs
chiru105317152chiru
chirus114615692chirus
chis95933312chi_s
chits105424572chits
choir105313602choir_
cigs75625112c_igs
cions75222852cions
cire65836382c_ire
cires74932912c_ires
cis57748042c_i_s
clips96018302clips
clours85215092clours
coals76129602coals
coarse84813902coarse
coats75635002coats
cobbs115013992cobbs
cobias104014992cobias
cobra95214402cobra
cobras104014192cobras
cobs87043142co_bs
cocas95926572cocas
cocks135227162cocks
cocos95624692cocos
codas84724242codas
coders95426982coders
codes86247292codes
cods76848112co_ds
coeds85920162coeds
coffs134916302coffs
cogs77340032co_gs
coheirs1236752coheirs
cohos105921852cohos
coif96337912coi_f
coign85013912coign
coigns94410062coigns
coil66439652coi_l
coilers93619902coilers
coin66645352coi_n
coiners93620752coiners
coitus8511892coitus
cokes115537192cokes
colas75436772colas
colds85726972colds
coles76055062coles
colics104219902colics
colies84837052colies
colins85229042colins
colors86622372colors
cols66553082co_ls
colts76633292colts
comas95833002comas
combs116122962combs
comers105328082comers
comes97246992comes
comics124015562comics
comps115526052comps
cones76457422cones
conics103920592conics
conies84338592conies
conins84327232conins
conks115525702conks
conns75024232conns
cons66057692co_ns
conus76726532conus
cooers84324562cooers
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492co_os
coots75636842coots
copers104629842copers
copes97747102copes
copiers114215962copiers
copies104130312copies
copra98115462copra
copras103517152copras
cops86751372co_ps
cor59960942co_r_
cord76740922co_rd
cords86030622cords
core67263112co_re
corers85231072corers
cores76361852cores
corf95941482co_rf
coria75828322coria
cork106635692co_rk
corks116028272corks
corm85735382co_rm
corms95626222corms
corn69945812co_rn
corns76034762corns
corps95927042corps
corse75036182co_rse
cory96941512co_ry
cos510270392co__s
coses76949492coses
cosies84932162cosies
coss66143492co_ss
costs77231142costs
cotes76347842cotes
cots68054842co_ts
coups95522472coups
course85117782course
court75532772court
courts84216172courts
covers114627962covers
coves105539172coves
covins114618062covins
cowers114625532cowers
cowls106922212cowls
cowry135512482cowry
cows97046642co_ws
coxes145430862coxes
coys97537242co_ys
cozes166033242cozes
cozies174521412cozies
cribs94516752cribs
criers83918582criers
cries75438402cries
cris66233432cri_s
crits75527572crits
cuifs104814692cuifs
currs75624392currs
curs65645542c_urs
czars164812912czars
doers65225712doers
doits66223672doits
doors65022132doors
dorrs65520592dorrs
dors56747602do_rs
emirs76116162emirs
fairs85825442fairs
firs76637722_firs
flirs85518932flirs
foils85025812foils
foins85523382foins
fours85521492fours
goers65520252goers
hairs86225172hairs
heirs85618562heirs
hoars85925552hoars
hoers85724922hoers
hours85422392hours
joins125818412joins
keirs95313682keirs
kirs85831752_kirs
kois85129412koi_s
kors85933022ko_rs
lairs55425872lairs
loids66220712loids
loins56728422loins
loris55329152loris
lours55125292lours
mairs76228302mairs
mirs66940582_mirs
moils76125752moils
moira71012022moira
moire71017322moire
moires8915632moires
moors74923142moors
mors65950062mo_rs
noils55024332noils
noir46722432noir_
noris54928272noris
oars46846032_oars
oils46337982_oils
ors35750112_o_rs
ours47237562_ours
pairs75325832pairs
pois66539042poi_s
pours74623182pours
roars55622242roars
roils54826792roils
scours84913592scours
sirs44338342_sirs
soars54732512soars
soils55327982soils
sours55230502sours
stirs55921622stirs
toils54527492toils
toits55327472toits
torrs53923562torrs
tors46157382to_rs
tours55325892tours
vairs85019132vairs
voids95414682voids
wairs86424062wairs
weirs84316492weirs
whirs115218092whirs
yours85217882yours
zoris145320012zoris

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.296603685.8
2DLD Change Limit538002311.65632487.9
3Display Results2312310.0603850.0
 (SQL Overall)1786912312.01288812.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.