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

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

74 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
criollo94395(None) 
criollos1043711criollos
brillo84211002bri_llo
apollo837183_apollo
arioso64312403ario_so
brill74819953bri_ll_
brillos9369183bri_llos
brills84916293bri_lls
brolly114510853br_olly
carillon1046963cari_llon
cariole9818343cario_le
carioles10817073carioles
cello74919583c__ello
chill105619873chi_ll_
chilli114312773chi_lli
chills114717703chi_lls
chilly144113223chi_lly
cholla113911023c_holla
cholo105217973c_ho_lo
collop107312313c__ollop
colly104926773c__olly
coolly114811393c_oolly
corolla938623corolla
creole8913733creo_le
creoles9913323creoles
creosol946053creosol
crimple13408693crimple
cringle103010353cringle
crinkle13359413crinkle
crinkly16387523crinkly
cripple13378583cripple
crisply14426523crisply
cruelly1236563cruelly
drill64718263dri_ll_
drills74414203dri_lls
droll65415403dr_oll_
drolls75312393dr_olls
drolly105411673dr_olly
fillo84319783_fi_llo
frill84917563fri_ll_
frills94414223fri_lls
frilly124111443fri_lly
girolle835793girolle
grill64617893gri_ll_
grille74315743gri_lle
grills74314803gri_lls
hillo84721653_hi_llo
hollo84822163__hollo
krill94213643kri_ll_
krills104211283kri_lls
niello636603_niello
oriole6814293orio_le
orioles7412993orioles
prill74117943pri_ll_
prills84015613pri_lls
priorly12335763priorly
rialto638603_rialto
rill45140903_ri_ll_
rille55728733_ri_lle
rills55032713_ri_lls
roll46331653_r_oll_
rolls55326233_r_olls
scroll8310173scr_oll_
scrolls938063scr_olls
trill55122933tri_ll_
trills64319853tri_lls
triol55521363trio_l_
triolet73219523triolet
triols66117803trio_ls
troll54416533tr_oll_
trollop944793tr_ollop
trolls64613943tr_olls
trolly94012363tr_olly
zorillo1644683zori_llo

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027746.42320866.7
3Display Results74740.0302466.7
 (SQL Overall)178691746.85926052.0
 
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.