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

66 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
ulcer731075(None) 
ulcers839381ulcers
alder65421912alder
alter54828502alter
aulder7511452aulder
bluer74918492bluer
bulger94917352bulger
culler84322252culler
culver113010632culver
dicer85426422dicer
dulcet9314492dulcet
duller74017702duller
elder64020022elder
elver85216242elver
facer105525052facer
fleer86020772fleer
flier86023402flier
flyer114916252flyer
fuller94220382fuller
gluer65116772gluer
gulper93410212gulper
huller93919102huller
iller54821292iller
juicer1536282juicer
lacer75833752lacer
leer46239352_leer
lier45942462_lier
luce65132572luce_
lucern846102lucern
luces75528432luces
lucre76415522lucre
luger65322082luger
luller63415482luller
lurer54625312lurer
macer912126942macer
muller83820352muller
nicer74618292nicer
older65121172older
pacer96131612pacer
placer105117742placer
plier75221282plier
plyer106214332plyer
puler74826622pul_er
puller83820812puller
pulper103513272pulper
pulser84215192pulser
racer75233022racer
ricer74726612ricer
ruler54923342rul_er
rulier65016352rulier
slicer84117602slicer
slier54827242slier
slyer85515122slyer
sulker104015922sulker
udder76314282udder
uglier748952uglier
ulcered1037972ulcered
ulnar56013982ulnar
ulster63712102ulster
umber94617592umber
under64624212under
upper93714262upper
urger64116472urger
user45023002u_ser
usher84517762usher
utter54218762utter

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit53800661.39038705.0
3Display Results66660.0164125.0
 (SQL Overall)178691661.702104988.8
 
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.