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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
cholas11481800(None) 
chelas113817201chelas
chola104718031chola_
chollas123811351chollas
cholos114716851cholos
colas75436771c_olas
acholias1349572acholias
aholds10469482aholds
bolas74733762_bolas
callas84526752callas
canolas9313992canolas
chalah143511662chalah
chalahs15289882chalahs
chalks155412142chalks
challas124414122challas
charas114223612charas
chela103916802chela_
chelae113614602chelae
chias104625522ch_ias
chicas135916472chicas
chiles115425302chiles
chilis115517872chilis
chills114717702chills
chimlas1437452chimlas
chinas115119402chinas
chocks174815312chocks
choirs114911882choirs
chokes154917382chokes
cholate122114932cholate
cholates132414762cholates
choler113717152choler
choleras13289042choleras
cholers124215202cholers
cholla113911022cholla
cholo105217972chol_o
chomps155112222chomps
chooks155312792chooks
chops125019872cho_ps
choral115118492choral
chorals124614112chorals
chords125214632chords
choreas124414202choreas
chores114828022chores
chorus115014772chorus
choses115825132choses
chotts113610992chotts
chows135618202cho_ws
chromas142512692chromas
chufas14397672chufas
chyles144813282chyles
citolas939362citolas
coalas87418962coalas
coals76129602c_oals
cocas95926572c_ocas
codas84724242c_odas
cola66541392c_ola_
colds85726972c_olds
coles76055062c_oles
cols66553082c_ol_s
colts76633292c_olts
colzas174010512c_olzas
comas95833002c_omas
cools75632632cool_s
cupolas11277752cupolas
cutlas8313102cutlas
dholes104914792dholes
holds94623242_holds
holes84748652_holes
holks124720562_holks
hollas94616902_hollas
holms105117802_holms
hols76946292_hol_s
holts85627912_holts
horas86333102_horas
hoyas115016162_hoyas
hulas84920882_hulas
hylas114815902_hylas
kolas94822232_kolas
molas75132092_molas
moolas83615592moolas
scholar1236952scholar
scholars1336682scholars
shoals94215792shoals
tholes94919782tholes
tholos94213002tholos
tolas54532772_tolas
violas93713522violas
wholes124616772wholes

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.373479064.3
2DLD Change Limit82551882.51632810.4
3Display Results88880.0302933.3
 (SQL Overall)178691882.91961216.5
 
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.