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

174 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
chiauses133648(None) 
causes88026472c__auses
chaises124317492ch_aises
chaoses124715122ch_aoses
chases115128232ch_a_ses
chasses124017502ch_asses
chausses1345962ch_ausses
chiasms14357522chia_sms
chiaus113611312chiau__s
chintses1337112chintses
choruses1339982choruses
chouses125117812ch_ouses
clauses93813322c_lauses
coituses1039622coituses
hiatuses1135772_hiatuses
aliases7914493alia_ses
animuses1037983animuses
biases84618433_bia_ses
biasses94911653_biasses
cactuses1237933cactuses
caiques18248793caiqu_es
calluses1039323calluses
camases114216343cama_ses
camasses12388973camasses
campuses1437773campuses
capiases1239253capia_ses
carouses10614503carouses
carses85233653c__arses
cases75048383c__a_ses
caucuses1236783caucuses
caules85927253c__aules
cause75225353c__ause_
caused95117043c__aused
causer84117783c__auser
causers94014793c__ausers
causey113513273c__ausey
causeys12387223c__auseys
cayuses12188403c_ayuses
ceases84427073c_ea_ses
censuses10187543censuses
cereuses1049243cereuses
ceruses93716233c_eruses
cestuses1038083cestuses
chafes145017913ch_a_fes
chaines124518733ch_aines
chaise114916413ch_aise_
chamises153513313chamises
chances145218093ch_ances
changes134517583ch_anges
chapes135421873ch_a_pes
charases131312763charases
chares115631803ch_a_res
charges134615983ch_arges
chase105127123ch_a_se_
chased125019293ch_a_sed
chaser114918383ch_a_ser
chasers123714923ch_a_sers
chasms135513143ch_a_sms
chasse115114603ch_asse_
chassed134712133ch_assed
chassis123910663ch_assis
chaufer15347943ch_aufer
chaufers16347303ch_aufers
chaunts1267083ch_aunts
cheapies1539033cheapies
cheeses123613103ch_eeses
chemises153211983chemises
cheques2136863chequ_es
chesses124112633ch_esses
chiantis1346593chiantis
chias104625523chia___s
chiasm13449103chia_s_m
chiasma14366993chia_sma
chiasmas15306593chiasmas
chiasmi14365583chia_smi
chiasmus15343913chiasmus
chicanes1559373chicanes
chickees19258513chickees
chicles143512503chi_cles
chicness1535593chicness
chides124620473chi__des
chigoes1338353chi_goes
childes134211273chi_ldes
chiles115425303chi__les
chilies124218303chi_lies
chillies134113483chillies
chimeres153511313chimeres
chimes134922573chi__mes
chinches18369373chinches
chines115029173chi__nes
chinless1337493chinless
chinones13510483chinones
chintzes2235973chintzes
chippies17309763chippies
chirres123812253chi_rres
chirus114615693chiru__s
chisel112111943chi__sel
chisels12219103chi__sels
chitties13310773chitties
chivarees1744383chivarees
chivaries1757433chivaries
chives144317593chi__ves
chivies153412853chi_vies
chivvies1954423chivvies
chlamyses1962493chlamyses
chooses125717433ch_ooses
choraguses1642543choraguses
chorused1446133chorused
chorusses1444883chorusses
choses115825133ch__oses
chouse116017563ch_ouse_
choused135012473ch_oused
chouser125212943ch_ouser
chousers134610203ch_ousers
choushes1637623ch_oushes
chowses155611283ch_owses
chutes114615773ch__utes
circuses1238253circuses
cistuses1038283cistuses
citruses1037483citruses
classes94717943c_lasses
clause84311503c_lause_
cleanses10358143cleanses
cliques18309203cliqu_es
clonuses1057133clonuses
coleuses1039723coleuses
confuses13310363confuses
contuses10413453contuses
cornuses10310033cornuses
corpuses12310063corpuses
crases85532313c_ra_ses
creases94020963crea_ses
crises84529433cri__ses
crocuses1239023crocuses
cruses88127713c__ruses
cuirasses1144373cuirasses
cuisses9319883cui_sses
cultuses1037753cultuses
cuscuses1235863cuscuses
cycases1437533cyca_ses
cypruses1534313cypruses
disuses84015413_disuses
ficuses12159203_ficuses
hanses95022633_h_anses
hausen9610383_h_ausen
hausens1077633_h_ausens
hawses125113993_h_awses
hearses104414543_hearses
heaumes1237423_heaumes
hisses94719353_hi_sses
hocuses121710433_hocuses
houses96032283_h_ouses
humuses1237603_humuses
liaises7311053_liaises
minuses93512703_minuses
misuses93216023_misuses
myiases1235493myia_ses
niduses837013_niduses
pauses84621473__pauses
phases114618403ph_a_ses
phimoses1537213phimoses
phrases12711463phra_ses
priapuses1343703priapuses
primuses1237083primuses
rhesuses1134893rhesuses
rhuses94911793rh__uses
risuses73210923_risuses
shamuses1336153shamuses
shiatsus1142613shiatsus
shikses14116573shi_kses
sinuses73011593_sinuses
situses72710493_situses
thymuses1643073thymuses
viruses1039413_viruses

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621746.64322002.4
3Display Results1741740.0762289.5
 (SQL Overall)1786911747.15524974.3
 
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.