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

135 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
sanga6602379(None) 
anga56831351_anga
fanga96119621fanga
manga85026191manga
panga85323531panga
saga55331171sa_ga
saiga64717931saiga
sang55441221sang_
sangar73617681sangar
sangas75222651sangas
sangh95517451sangh
tanga64923681tanga
aga410447232_a_ga
alga57927602_alga
ana39559822_an_a
angas65827982_angas
anna45529012_anna
anoa45634472_anoa
ansa45927772_ansa
anta46839582_anta
asana5315482asan_a
banda85223102banda
bang74836992bang_
bangs85627772bangs
canna75919332canna
conga85419872conga
dagga839542dagga
dang65131532dang_
dangs75623202dangs
donga76718422donga
fanega1055782fanega
fang85432542fang_
fangas105017192fangas
fangs96224072fangs
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
sabra75317852sabra
sacra74516992sacra
sag46163402sa_g_
sagas66025882sa_gas
sage55044592sa_ge
saggar84010852saggar
saggy105917462saggy
sago56332672sa_go
sags55948402sa_gs
sagy85327082sa_gy
saigas74114292saigas
salpa75018352salpa
salsa56718922salsa
samba95618772samba
sancta839832sancta
sand55338462san_d
sandal73317282sandal
sands65228582sands
sandy94221132sandy
sane45954332san_e
saned65636272saned
saner54334322saner
sanes55649072sanes
sangars83116252sangars
sanger74524562sanger
sanghs105312062sanghs
sangria838112sangria
sanjak1735692sanjak
sank85236822san_k
sans45153352san_s
sansar63613392sansar
santo56227282santo
sarge65531132sarge
sargo65424412sargo
saugh95318402saugh
sauna54117552sauna
senega738172senega
sengi64016512sengi
senna54617982senna
sensa54117472sensa
signa66114702signa
sing57544172sing_
singe65731132singe
sings65532702sings
slang66324022slang_
slangs75615342slangs
slangy105411392slangy
snag55827872snag_
snags64421312snags
song55133672song_
songs67725552songs
spang84919732spang_
stang66424682stang_
stangs75018162stangs
stanza1537072stanza
sung55832172sung_
sunna55016062sunna
swang95519722swang_
syngas10368912syngas
taiga64115652taiga
tang56138662tang_
tango66921172tango
tangs65028342tangs
tangy94519932tangy
tanka93817482tanka
tonga65619682tonga
vanda94515922vanda
vang84926032vang_
vangs96319582vangs
wangan10311222wangan
yang85626062yang_
yangs95618692yangs
zanza1378702zanza

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 Filter178691538000.0931921408.6
2DLD Change Limit538001351.87328724.0
3Display Results1351350.0334090.9
 (SQL Overall)1786911351.99989390.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.