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

95 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
chrisom146662(None) 
chrism13710671chris_m
chrisoms1566091chrisoms
charism14712202charis_m
chrisma1456822chrisma
chrismon1544642chrismon
chrisms1499142chrisms
christy1536622christy
caribou1156993caribou
carom95025563car__om
carrom10513403car_rom
cerise84822043ceris_e
cerises94722253cerises
cerium10313763ceri_um
chais107530313chais__
chaise114916413chais_e
chaises124317493chaises
chamiso14348653chamiso_
chamisos15307423chamisos
chanson1238043chanson
chariot12316213chari_ot
charisma1576363charisma
charisms15710263charisms
chasm125518793ch_as_m
chefdom18134073chefdom
chemism16339303chemis_m
cherish15310463cheris_h
chiao105618363ch_iao_
chiasm13449103ch_iasm
chico124218253ch_ico_
chicos134614833ch_icos
chigoe1237533ch_igoe
chino105823313ch_ino_
chinos115018693ch_inos
chirm125317063ch_i_rm
chiro105320343ch_iro_
chiros114617773ch_iros
chis95933313ch_is__
chisel112111943ch_isel
chiton112612393ch_iton
chorion12311773chori_on
chorizo2136323chorizo_
chorizos2245493chorizos
chrismal1575173chrismal
chrismons1644003chrismons
christen13106703christen
christie1347783christie
chroma132912473chr__oma
chrome133214813chr__ome
chromo132811013chr__omo
chromos142610273chromos
chromy16309903chr__omy
chronon1237353chronon
civism1337243civis_m
corium10315723cori_um
cortisol1045403cortisol
cresol8310213c_resol
crimson1135643c_rimson
crinum1039333c_rinum
cris66233433c_ris__
crises84529433c_rises
crisic103611843c_risic
crisis83716343c_risis
crisp95014623c_ris_p
crisps104411513c_risps
crispy13478563c_rispy
crissa837623c_rissa
crissum1144843c_rissum
crista8311803c_rista
cubism12348703cubis_m
curio74221213curi_o_
curios83218333curi_os
curiosa9346643curiosa
curium10312503curi_um
cursor84110293cur_sor
czarism2056423czaris_m
echoism1447363echois_m
grison7310103_grison
hansom11219153_hansom
lyrism1137473lyris_m
ogrism937913ogris_m
orison6411663_orison
porism104518063poris_m
prism94820263_pris_m
prison8514023_prison
purism104715063puris_m
schism1338173sch_is_m
shris84221453shris__
theism1139483theis_m
trisome9310223_trisome
trisomy1235943_trisomy
verism113214263veris_m
verismo12276393verismo
warison1037083warison
whilom1436133wh_ilom

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.406440125.6
2DLD Change Limit134027956.89019452.4
3Display Results95950.0332878.8
 (SQL Overall)178691957.32924381.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.