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

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

81 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
chrismation185351(None) 
chrismations1953041chrismations
charismatic2053543charismati_c
charismatics2152423charismatics
chrismon1544643chrism___on
chromatin16410753chr_omati_n
coruscation1545693coruscation
cremation13511643c_r_emation
himation1339753_h_i_mation
acclimation17127094accli_mation
affirmation1953684affirmation
animation11313684_ani_mation
calibration1545994calibration
capitation14311364capi_tation
carbonation1545854carbonation
carnation11312944car__nation
caseation1199514c__aseation
cassation1197914c__assation
causation1199524c_aus_ation
cavitation1549134cavi_tation
cerebration1547924cerebration
cessation1176854c__essation
charismata1752814charismat__a
chelation1439964ch__elation
chiasmatic1954344chiasmati_c
chlorination1756244chlori_nation
chrisma1456824chrisma____
chrismal1575174chrisma___l
chrismons1644004chrism___ons
christen13106704chris__t_en
christie1347784chris__ti_e
christies1449264chris__ties
chromatic18412334chr_omati_c
chromatics1948684chr_omatics
chromatid17410914chr_omati_d
chromatids1847174chr_omatids
chromatins1749124chr_omatins
ciliation111112494c__iliation
circulation1549394circulation
citation10314364c__i_tation
cogitation13410084cogi_tation
collimation1557574collimation
confirmation1946184confirmation
confiscation1945534confiscation
coronation12412074cor_onation
corotation12410974cor_otation
corporation151210654corporation
correlation1358554correlation
corrugation1445994corrugation
coruscations1645244coruscations
creation102816514c_r__eation
cremations14410714c_r_emations
crenation11412924c_r_enation
crimination1549414c_rimination
decimation15411624deci_mation
derivation14712784deri_vation
estimation12410844esti_mation
forestation1447004forestation
formation1439424for__mation
hesitation1349634_hesitation
himations1438804_h_i_mations
intimation12413044inti_mation
irrigation1147804irri_gation
irritation1048974irri_tation
lacrimation1546264lacri_mation
legislation1244284legislation
marination12312814mari_nation
prismatic1547164_prismati_c
prismatoid1552974_prismatoid
privation14311174_pri_vation
restation9316914__restation
schismatic1954644sch_ismati_c
schismatics2053454sch_ismatics
schismatize2753004sch_ismatize
seriation9318064seri__ation
striation9313484stri__ation
trisection1245984_trisection
urination9312174_uri_nation
variation12312394vari__ation
variegation1543454variegation
workstation1852304workstation

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819818.30017930.0
3Display Results81810.0461760.9
 (SQL Overall)178691818.76620384.6
 
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.