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

67 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
flange10341197(None) 
flanged123810841flanged
flanger113412621flanger
flanges113413271flanges
alane56135612alan_e
alang66023512alang_
blunge94311482blunge
change124116752change
clang86019312clang_
clanged114212652clanged
clanger104113492clanger
clangs95113612clangs
fadge104817002f_adge
fane75343572f_an_e
fang85432552f_ang_
fanga96119622f_anga
fanged114318222f_anged
fangs96224072f_angs
fiance11310742fiance
flag87427082fla_g_
flagged13459632flagged
flagger12469352flagger
flaggy14415922flaggy
flags95321282fla_gs
flake125119972fla_ke
flambe13489152flambe
flame105124442fla_me
flan76134182flan__
flanes94522422flanes
flangers123311372flangers
flank124618092flan_k
flanked153710642flanked
flanken14226762flanken
flanker143911292flanker
flanks133913402flanks
flannel1035422flannel
flans85327972flan_s
flare84823632fla_re
fledge11439312fledge
flense938902flense
fling97023512fling_
flinger113710512flinger
flings106715282flings
flong95815682flong_
flongs105010492flongs
flung95114582flung_
fringe104013952fringe
glance94312312glance
grange83716202grange
lance75126722_lance
lane45153332_lan_e
lang56637382_lang_
langue71012172_langue
large65325462_large
longe66626462_longe
lunge65323802_lunge
mange84930192_mange
melange1038362melange
orange74016322orange
plage84520402pla_ge
plane74929142plan_e
plunge93811052plunge
range64728412_range
slang66324022slang_
slanged94112852slanged
slangs75615342slangs
slangy105411392slangy

Search took 3 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.343520965.0
2DLD Change Limit82551672.26636430.3
3Display Results67670.0164187.5
 (SQL Overall)178691672.62568072.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.