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

68 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
wedels10381103(None) 
bedels94015271bedels
wedel94513961wedel_
wedeln10326691wedeln
wedelns11325241wedelns
aedes64625152aede_s
bedel84219402bedel_
bedell93610042bedell
bedells10379362bedells
bedews12398942bedews
betels84515062betels
bevels113913982bevels
bezels173712282bezels
ceders93817672ceders
cedes84927332cede_s
dels56745472__dels
devels104313902devels
eels46536742_e_els
feels85223042fe_els
heders104119762heders
heels85625532he_els
jebels15418912jebels
jewels16508612jewels
keels94622412ke_els
kevels134410712kevels
levels94113282levels
medals94218062medals
models94216362models
newels93710822newels
pedals94316032pedals
pedes85327292pede_s
peels75226422pe_els
rebels84518132rebels
redes65139132rede_s
reels55333262re_els
refels94618052refels
repels84318762repels
revels94220572revels
seders74420282seders
seels55632822se_els
seidels838392seidels
swedes102711892swede_s
teels55726372te_els
waders109120652waders
wades95634142wade_s
wadmels1334302wadmels
weals85428742we_als
weasels10468502weasels
webers11310942webers
wedders123610722wedders
wedeled1237782wedeled
wedges114614582wedges
weds86628942wed__s
weeders113412932weeders
weeds95222212we_eds
weeks125017862we_eks
weel75834082we_el_
weens85224052we_ens
weeps104120562we_eps
wees76249122we_e_s
weets85427722we_ets
welders113313412welders
wells85426192we_lls
wheels123811722wheels
widely133311032widely
widens106212722widens
wides94832832wide_s
yodels104610072yodels

Search took 6 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 Filter178691825510.703254183.5
2DLD Change Limit82551685.06316304.8
3Display Results68680.0461478.3
 (SQL Overall)178691685.81230745.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.