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

55 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
demersal114526(None) 
deferral1244352deferral
demurral1143942demurral
deverbal1444482deverbal
reversal1145842reversal
bimensal1244093bimensal
cameral11311283camer_al
decretal1146353decretal
decrial10310323de_crial
deers64930523de_ers__
deferrals1343683deferrals
defers105116943defers__
demean9510563deme__an
demential1248683demential
demerara1144853demerara
demeraran1253153demeraran
demeraras1243733demeraras
demerge11168023demer_ge
demerged13157603demerged
demerger12127373demerger
demerges12129503demerges
demerit10314993demer_it
demerits11310763demerits
demes86032693deme_s__
demesne1035573deme_sne
demurrals1243023demurrals
demurs939773demurs__
deposal1037153de_posal
dermal93614343d__ermal
despisal1144673despisal
deters74724683deters__
deverbals1544103deverbals
devisal1136913de_visal
dextral1577003dextr_al
dimers94321093dimers__
dispersal1246003dispersal
dorsal74613943d__orsal
emerald1046923_emer_ald
emersed10138513_emersed
eternal72910893_eternal
federal1148533feder_al
femoral1238723femor_al
general81010933gener_al
gomeral1038833gomer_al
humeral1238563humer_al
memorial1249523memorial
mensal84615653__mensal
numeral939083numer_al
referral1144403referral
rehearsal1242343rehearsal
remedial1147543remedial
reversals1245203reversals
several1039533sever_al
venereal1145083venereal
versal93013753__versal

Search took 7 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.423422437.4
2DLD Change Limit146162556.43622710.1
3Display Results55550.0163437.5
 (SQL Overall)178691556.87525991.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.