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

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

155 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
fugato103622(None) 
fugatos1135481fugatos
fugal95613032fuga_l
fugio9310922fug_io
jugate14379462jugate
legato72810952legato
rubato8319682rubato
rugate75813812rugate
sfumato1253682sfumato
agate66525153_agate
aught95120703aught_
aughts104710243aughts
augite7312613augite
aurate64426473aurate
auto47432083au__to
begat86629723begat_
bugaboo1244313bugaboo
cogito939203cogito
cuatro838433cu_atro
curate85226243curate
curator9312213curator
dato56129943__dato
ducat86225903ducat_
ducats95011763ducats
ergate7315143ergate
fado87226463f__ado
faggot1139053faggot
fagot9323403fagot_
fagots1039963fagots
fano75831693f__ano
faro76136923f__aro
fat68178083f__at_
fate75444283f__ate
fats76252503f__ats
fatso85113493f__atso
feat76458223f_eat_
feats86432753f_eats
fiat76646643f_iat_
fiats85324483f_iats
fight124027093fight_
fights133816553fights
finito9310303finito
fixate1638733fixate
flat77147823f_lat_
flats86429743f_lats
float85928573float_
floats96816253floats
floaty124210943floaty
fluxgate1942893fluxgate
folate93320393folate
forgat104018583forgat_
fought135112393fought_
frat75648543f_rat_
frats86829673f_rats
frigate11311063frigate
frugal1036393fruga_l
fubar1039923fuba_r
fug76234513fug___
fugacity1743313fugacity
fugally1435603fugally
fugged124615383fugged
fuggy135411673fug_gy
fugios1037583fugios
fugle94915543fug_le
fugled114813693fugled
fugles104715783fugles
fugs85730693fug__s
fugu85419863fug__u
fugue94313373fug_ue
fugued11478713fugued
fugues104511683fugues
fugus95914013fug_us
fumatory1644923fumatory
fumet105630223fumet_
fumets114311813fumets
fumigate1446153fumigate
fumigator1543923fumigator
functor1235203functor
fungal10388733funga_l
fungals11276783fungals
fungo94413133fu_ngo
furan84320013fura_n
furane94015493furane
furans94515953furans
furcate12310453furcate
fusain958643fusain
fusty115016513fu_sty
futon83113773fu__ton
futz167823803fu__tz
gat46880513__gat_
gate55746573__gate
gator64416033__gator
gats56753443__gats
gelato73812953gelato
gigaton946343gigaton
guaco85012163gu_aco
guano69213983gu_ano
gusto65414643gu_sto
humate113214443humate
ingate73018243ingate
jato115822683__jato
juga126417323juga__
jugal135612403juga_l
junto125114563ju_nto
jurat124829323jurat_
jurats134213203jurats
legate72917453legate
legator83011133legator
legatos82711183legatos
ligate72519253ligate
lunate6316043lunate
luxate1338083luxate
megaton10269853megaton
mulatto944733mulatto
mutate83017483mutate
negate72915573negate
negaton8299143negaton
negator83010673negator
nougat74712653nougat_
nougats8427413nougats
nugatory1245273nugatory
nutate63017373nutate
ought95221533ought_
oughts104710183oughts
outate62923403outate
potato8513433potato
punto75121323pu_nto
pupate104213123pupate
putto75617663pu_tto
quarto153511123quarto
quate144521413qu_ate
rabato83413263rabato
rato45436973__rato
rebato83714683rebato
righto104111093righto
rubati8299693rubati
rubatos9278653rubatos
ruga56121233ruga__
rugae65114763ruga_e
rugal65916093ruga_l
sfumatos1353343sfumatos
subatom1147053subatom
subito8410453subito
sugar6312913suga_r
sugars7312423sugars
sugary1039013sugary
togate74515683togate
tomato8313453tomato
tubate82813173tubate
turaco839453turaco
unto45824283_u_nto
urate55432163_urate
vulgate11388433vulgate
yuga85615423yuga__
yugas95012063yuga_s

Search took 7 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 Filter1786911127160.403443402.0
2DLD Change Limit1127161555.86019234.8
3Display Results1551550.0632460.3
 (SQL Overall)1786911556.32628247.1
 
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.