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

201 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
chines11502917(None) 
chaines124518731chaines
chides124620471chides
chiles115425301chiles
chimes134922571chimes
chinas115119381chinas
chine105231721chine_
chined125620061chined
chinks155817571chinks
chinos115018691chinos
chins105631461chin_s
chints115117831chints
chives144317591chives
cines75239681c_ines
clines84926041clines
shines95028911shines
whines125120101whines
achenes12313492achenes
achiness1339702achiness
alines65735222alines
amines84727982amines
archines133815252archines
azines155517072azines
bines76946792_bines
brines85028852brines
cains75334302cain_s
canes75350372c_anes
canines93724032canines
chafes145017912chafes
chaine115119222chaine_
chained133812692chained
chains114819702chain_s
chaises124317492chaises
chances145218092chances
changes134517582changes
changs125215372changs
chants115020392chants
chapes135421872chapes
chares115631802chares
chases115128232chases
chias104625512chi_as
chiaus113611302chiaus
chicanes1559372chicanes
chicas135916462chicas
chicer134513602chicer
chicest14209942chicest
chicks175317592chicks
chicles143512502chicles
chicness1535592chicness
chicos134614832chicos
chics123920942chi_cs
chide115321012chide_
chided135113962chided
chider125116052chider
chiders135312942chiders
chief134419472chi_ef
chiefs14509652chiefs
chiel104918972chi_el
chiels115115932chiels
chigoes1338352chigoes
childes134211272childes
chile105626892chile_
chilies124218302chilies
chilis115517872chilis
chills114717702chills
chimbs153910302chimbs
chime125322592chime_
chimed145814832chimed
chimer135517202chimer
chimers144515132chimers
chimney1795482chimney
chimneys1883642chimneys
chimps155713662chimps
chin96934742chin__
china105022472chin_a
chinch163911222chinch
chinches18369362chinches
chink145321592chin_k
chinked174011022chinked
chinky185610542chinky
chinless1337492chinless
chinned134810492chinned
chino105823312chin_o
chinones13510472chinones
chintses1337112chintses
chintz204212022chintz
chintzes2235962chintzes
chips125721252chi_ps
chirks155414842chirks
chirms135113982chirms
chiros114617772chiros
chirps135414002chirps
chirres123812252chirres
chirrs114514982chirrs
chirus114615692chirus
chis95933312chi__s
chisel112111942chisel
chisels12219102chisels
chits105424572chi_ts
chive135117622chive_
chivies153412852chivies
choices142010612choices
chokes154917382chokes
cholines132214482cholines
chopines152711732chopines
chores114828022chores
chorines132917252chorines
choses115825122choses
chunks154210332chunks
chutes114615762chutes
chyles144813282chyles
chymes165912152chymes
cine66242942c_ine_
cires74932912c_ires
cites74435582c_ites
climes104720002climes
cline76428532cline_
clings95716212clings
clinks125815062clinks
clones84526562clones
cohunes1249712cohunes
coignes103912152coignes
coined94523602coined
coiner84323782coiner
coiners93620752coiners
coins75834552coin_s
cones76457422c_ones
conies84338592conies
conines93827792conines
cosines94122672cosines
cranes84330752cranes
cries75438402cri_es
crimes105521582crimes
cringes103215502cringes
cripes105120872cripes
crises84529432crises
crones84729242crones
dines66449152_dines
dwines105013102dwines
echinus1236202echinus
exines135715802exines
fines86644262_fines
hides95129422_hides
hies74842832_hi_es
hikes125426982_hikes
hinds96721472_hinds
hinges105121022_hinges
hins76447992_hin_s
hints87330622_hints
hires86134342_hires
hives116925512_hives
hones88144492_hones
imines84918342imines
kines95039132_kines
koines10415732koines
lines57054572_lines
machines15312882machines
mines75651952_mines
nines55937342_nines
opines84820702opines
ovines94614342ovines
phizes20389132phizes
phones114121212phones
pines76048862_pines
rhinos94411122rhinos
seines65029902seines
shies86136552shi_es
shine85533092shine_
shined104620782shined
shiner93820872shiner
shiners104015942shiners
shins85131042shin_s
shires95225572shires
shives124921412shives
shrines104618692shrines
sines55954822_sines
spines85132032spines
thanes94918982thanes
theines104013232theines
thine85026852thine_
things104914282things
thinks134613352thinks
thins85826322thin_s
tines54848422_tines
trines64132562trines
twines94717272twines
urines64724122urines
vahines133410522vahines
vines85137642_vines
wahines133111172wahines
whiles124418012whiles
whine116022812whine_
whined134715202whined
whiner124516632whiner
whiners134011572whiners
whiney155012642whiney
whinges143610622whinges
whins114922332whin_s
whites123919882whites
wines85546862_wines
zines145232652_zines

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 Filter178691825510.1061685764.2
2DLD Change Limit825512012.12638829.3
3Display Results2012010.0633190.5
 (SQL Overall)1786912012.29577861.0
 
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.