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

40 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
crepitates148590(None) 
crepitate1385951crepitate_
crepitated1584741crepitated
decrepitates1793072decrepitates
capitate121712183c_apitate_
capitated14159043c_apitated
cavitates14168963c_avitates
celibates1358633c_elibates
cogitates1247863c_ogitates
craniates11310653crani_ates
creates95225203cre___ates
cremates124216003cre__mates
crenelates1266193crenelates
crepitant1346313crepita_nt
crepitating1645803crepitating
crepitation1548393crepitation
crepitations1647473crepitations
crewmates16375803cre_wmates
criminates1448003criminates
decrepitate1693093decrepitate_
decrepitated1872613decrepitated
depilates12310923_depilates
epilates10313503__epilates
epitases1038933__epitases
gravitates1444843gravitates
hesitates1269793_hesitates
irritates977223ir_ritates
levitates1247863_levitates
meditates1239813_meditates
palpitates1445303palpitates
precipitates1854633precipitates
predicates15410823predicates
propitiates1546203propitiates
redictates1348233_redictates
replates102919273_rep_lates
replicates1449453_replicates
resinates9314763_resinates
resituates1047753_resituates
restates83423433_re_states
veritates12310973_veritates

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 Filter1786911406030.420425454.8
2DLD Change Limit140603406.59321326.1
3Display Results40400.0162500.0
 (SQL Overall)178691407.02925422.0
 
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.