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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
fanga9611962(None) 
anga56831351_anga
fanega1055781fanega
fang85432541fang_
fangas105017191fangas
fangs96224071fangs
manga85026191manga
panga85323531panga
sanga66023791sanga
tanga64923681tanga
aga410447232_a_ga
alga57927602_alga
ana39559822_an_a
angas65827982_angas
anna45529012_anna
anoa45634472_anoa
ansa45927772_ansa
anta46839582_anta
banda85223102banda
bang74836992bang_
bangs85627772bangs
canna75919332canna
conga85419872conga
dagga839542dagga
dang65131532dang_
dangs75623202dangs
donga76718422donga
facia103218462facia
fadge104816992fadge
faena85014202faena
fag76852362fa_g_
faggy136514372faggy
fags86939122fa_gs
fan67158852fan__
fancy134615482fancy
fane75343562fan_e
fanegas1145712fanegas
fanes84639892fanes
fanged114318222fanged
fanny114816042fanny
fano75831682fan_o
fanon84619012fanon
fanos85926502fanos
fans76247362fan_s
fanum10313442fanum
fatwa1168062fatwa
faugh125712962faugh
fauna84816512fauna
fava106820262fa_va
finca104714502finca
flange103411972flange
fungal10388732fungal
fungi95014132fungi
fungo94413132fungo
gaga66625552ga_ga
gang66031962gang_
gangs76222572gangs
ganja131410002ganja
hang85535542hang_
hangar104114502hangar
hangs95726722hangs
hansa85416782hansa
kana85928522kan_a
lang56637372lang_
linga66820812linga
mana65341942man_a
mangas94122922mangas
mange84930182mange
mango85724312mango
mangy115021232mangy
mania75634142mania
manna75522532manna
manta75629902manta
nana46632892nan_a
panda85022612panda
pang75336282pang_
pangas99921102pangas
pangs84628662pangs
raga55930812ra_ga
rang56939152rang_
range64728412range
rangy95320382rangy
saga55331172sa_ga
saiga64717932saiga
sang55441222sang_
sangar73617682sangar
sangas75222652sangas
sangh95517452sangh
taiga64115652taiga
tang56138662tang_
tango66921172tango
tangs65028342tangs
tangy94519932tangy
tanka93817482tanka
tonga65619682tonga
vanda94515922vanda
vang84926032vang_
vangs96319582vangs
wangan10311222wangan
yang85626062yang_
yangs95618692yangs
zanza1378702zanza

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.0931921408.6
2DLD Change Limit538001021.64032804.9
3Display Results1021020.0303400.0
 (SQL Overall)1786911021.763101356.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.