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 “criminate” 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
criminate134898(None) 
criminated1546821criminated
criminates1448001criminates
brominate1348852brominate
circinate1347812circinate
criminal1248302crimina_l
criminals1346302criminals
crimine112413472crimin__e
culminate1347812culminate
eliminate1147732eliminate
incriminate1554592incriminate
originate1047022originate
recriminate1555232recriminate
ruminate10511472_ruminate
abominate1347023abominate
acuminate1347573acuminate
agminate1139243_agminate
aluminate1149373aluminate
brominated1546403brominated
brominates1448013brominates
carinate103320253c_arinate
caseinate1148243caseinate
catkinate1545823catkinate
ciliate9514603c_ili_ate
climate11312833clim__ate
comminute1596153comminute
craniate10312563crani_ate
cremate113816183crem__ate
crenate93317113cr__enate
crepitate1385953crepitate
criminality1855223criminality
criminalize2455283criminalize
criminally1746193criminally
criminating1646853criminating
crimination1549413crimination
crimini11258883crimin__i
criminis12257303crimin_is
criminous1375323criminous
criminy14268453crimin__y
crinite9513633cr__inite
crispate1246913cri_spate
cristate10310603cri_state
cruciate1287313cruci_ate
culminated1546103culminated
culminates1447053culminates
deaminate12410173deaminate
discriminate17164803discriminate
dominate11312853_dominate
eliminated1345953eliminated
eliminates1246973eliminates
fulminate1446553fulminate
geminate11411813_geminate
germinate1248633germinate
imitate9310873__imitate
incriminated1754063incriminated
incriminates1654323incriminates
laminate103014633_laminate
nominate10312473_nominate
ordinate9310253or_dinate
originated1244813originated
originates1145963originates
primate111516283prim__ate
primine113214823primin__e
recriminated1754493recriminated
recriminates1654883recriminates
resinate8316773_resinate
ruinate7312833_r_uinate
ruminated1258663_ruminated
ruminates11410193_ruminates
staminate1187983staminate
terminate11411203terminate
tribunate1144953tribunate
tripinnate1252693tripinnate
urinate7315363ur__inate

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 Filter1786911486410.430415560.5
2DLD Change Limit148641747.39620097.5
3Display Results74740.0401850.0
 (SQL Overall)178691747.86622716.9
 
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.