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

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

57 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
dirams9441370(None) 
diram84419471diram_
dirhams13376311dirhams
drams86025831d_rams
zirams17438641zirams
crams96229152_crams
dams77444372d__ams
derats74625062derats
derays105514252derays
dermas94116812dermas
derms85022892der_ms
diagrams1246132diagrams
dials64925342di_als
digamy1335892digamy
dims75435022di__ms
dinars75417562dinars
diorama1046532diorama
dioramas1145512dioramas
dirdums1134382dirdums
dirges84915102dirges
dirham12378272dirham_
dirks105619522dir_ks
dirls64720502dir_ls
dirts66824462dir_ts
disarms1039042disarms
ditas65923672dita_s
divans104612392divans
divas95418582diva_s
diwans105110372diwans
dorms85723842dor_ms
drabs85119672d_rabs
drags75521112d_rags
dram75832002d_ram_
drama85117422d_rama
dramas95814662d_ramas
drats66628372d_rats
draws95119372d_raws
drays95819772d_rays
dreams94513982dreams
drums85415872d_rums
dunams937832dunams
duras65727732dura_s
durums948152durums
firms105217422fir_ms
forams115115912forams
grams85327312_grams
ihrams1137172ihrams
imams91511112_imams
jorams154810532jorams
liras56021982lira_s
nizams1735412nizams
prams96125512_prams
rams65950772__rams
scrams105216622scrams
thirams1236822thirams
trams75327672_trams
ziram163912892ziram_

Search took 10 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 Filter178691825511.190150160.5
2DLD Change Limit82551577.81310565.9
3Display Results57570.0461239.1
 (SQL Overall)178691579.04919747.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.