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

115 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
crimson113564(None) 
crimsons1245631crimsons
caisson936592caisson
chrismon1544642chrismon
crampon1336942crampon
crimsoned1443802crimsoned
encrimson1351322encrimson
frisson1045312frisson
grison7310102gri_son
orison6411662ori_son
prison8514022pri_son
ramson8310462_ramson
acrimony1543563acrim_ony
acromion1246063acromion
arioso64312403arioso_
ariosos7409853ariosos
arisen65316793ari_sen
arson55118833ar__son
bison75716983_bi_son
bridoon1046203bridoon
brims94721623brims__
brimstone1354623brimstone
brimstony1642403brimstony
caiman103615663caim_an
caissons1036283caissons
camion103917193c_amion
carillon1046963carillon
chanson1238043chanson
chiffon1844053chiffon
chignon1344623chignon
chiton112612393chi_ton
chrismons1644003chrismons
chrisom1466623chri_som
cion613330913c_i__on
citron83112983c_itron
classon937693classon
coition9314313coition
common12310803c_ommon
crambo1238043crambo_
crambos1336783crambos
crampons1436643crampons
crampoon1444543crampoon
crams96229153crams__
craton84517193cr_aton
crayon114110003cr_ayon
creosol946053creosol
crepon1039943cr_epon
cresol8310213cr_esol
cribs94516753cribs__
cries75438403cries__
crime94822693crim__e
crimes105521583crim_es
crimine112413473crimine
crimini11258883crimini
criminy14268453criminy
crimmer133310773crimmer
crimp115615803crim__p
crimped143910763crimped
crimper136510423crimper
crimping15299783crimping
crimple13408693crimple
crimps124613453crim_ps
crimpy15489393crim_py
crimsoning1542943crimsoning
cris66233433cri_s__
crises84529433cri_ses
crisic103611843cri_sic
crisis83716343cri_sis
crisp95014623cri_s_p
crispen11348203crispen
crisps104411513cri_sps
crispy13478563cri_spy
crissa837623cri_ssa
crissal937413crissal
crissum1144843crissum
crista8311803cri_sta
crits75527573crits__
croon75522783cr__oon
croton84415453cr_oton
crouton947133crouton
crumhorn1542893crumhorn
daimon9259713daim_on
damson938063_damson
dromon939363drom_on
encrimsons1461203encrimsons
foison948933foi_son
frissons1145043frissons
gibson935123_gibson
griffon1443103griffon
grisons838993gri_sons
orisons7310563ori_sons
plimsol1143343plimsol
poison8312223poi_son
primo95017913prim_o_
primos104514423prim_os
prims95425933prims__
primsie1137543primsie
prion75119993pri__on
prisons9313223pri_sons
ramsons939563_ramsons
reason62616333_reason
ribbon1036533_ribbon
rimose8310593_rimose
rims65936303_rims__
rimshot1246213_rimshot
risen54621883_ri_sen
scrims104615933scrims__
simoon858063_simoon
stemson945163stemson
treason748763treason
trigon74513103tri_gon
trims75021473trims__
triton63914893tri_ton
unison649033uni_son
warison1037083wari_son

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271157.48317910.9
3Display Results1151150.0333484.8
 (SQL Overall)1786911157.90922593.4
 
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.