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

82 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
chrisoms156609(None) 
chrisms1499141chris_ms
chrisom1466621chrisom_
charisms15710262charis_ms
chrism13710672chris_m_
chrisma1456822chris_ma
chrismon1544642chrismon
chrismons1644002chrismons
caribous1258823caribous
carious93320283cari_ous
caroms105619573car__oms
carroms11512403car_roms
cerises94722253ceris_es
ceriums1139473ceri_ums
chaises124317493chais_es
chamisos15307423chamiso_s
chansons1337473chansons
chariots1339393chari_ots
charism14712203charis_m_
charisma1576363charis_ma
charismas1655313charismas
chasms135513143ch_as_ms
chefdoms19123493chefdoms
chemisms17278213chemis_ms
cherishes1767563cherishes
chiasms14357523ch_iasms
chicos134614833ch_ico_s
chigoes1338353ch_igoes
chinos115018693ch_ino_s
chirms135113983ch_i_rms
chiros114617773ch_iro_s
chisels12219103ch_isels
chitons122611913ch_itons
chorions13310663chori_ons
chorizos2245493chorizo_s
chrismal1575173chrismal
christen13106703christen
christens14125413christens
christie1347783christie
christies1449263christies
christy1536623chris_ty
chroma132912473chr__oma
chromas142512693chr__omas
chrome133214813chr__ome
chromes142914933chr__omes
chromo132811013chr__omo
chromos142610273chr__omos
chromous15258343chromous
chromy16309903chr__omy
chronons1347353chronons
civisms1436073civis_ms
cortisols1144783cortisols
cresols939643c_resols
crimsons1245633c_rimsons
crinums1135863c_rinums
crises84529433c_ris_es
crisis83716343c_ris_is
crisps104411513c_ris_ps
cubisms13306883cubis_ms
curios83218333curi_o_s
curious93813563curi_ous
curiums1138503curi_ums
cursors93910023cur_sors
czarisms2155753czaris_ms
echoisms1546143echois_ms
grisons838993_grisons
hansoms12238523_hansoms
lyrisms1235653lyris_ms
ogrisms1036443ogris_ms
orisons7310563_orisons
porisms113713453poris_ms
prisms104915503_pris_ms
prisons9313223_prisons
purisms114110833puris_ms
schisms1437173sch_is_ms
theisms1237763theis_ms
trisome9310223_trisome
trisomes1039833_trisomes
trisomy1235943_trisomy
verismos13284693verismos
verisms123011253veris_ms
warisons1136903warisons

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.1561145455.1
2DLD Change Limit146162827.01320841.6
3Display Results82820.0332484.8
 (SQL Overall)178691827.20224811.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.