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

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
fatuity133604(None) 
acuity1139372_acuity
faculty1535572faculty
falsity1335912falsity
fatality1438442fatality
fattily13379462fattily
fatty115117412fat__ty
faulty12429362fa_ulty
fortuity1465572fortuity
fruity12429702f_ruity
futurity1454892futurity
gratuity1244282gratuity
maturity1367442maturity
vacuity1545762vacuity
amity10416093_a_mity
annuity1045543annuity
aunty85919813_a_unty
batty105422243bat__ty
caducity1643883caducity
catsuit959393catsuit_
catsuits1045433catsuits
cattily123210853cattily
catty104520413cat__ty
cavity14310013ca_vity
dacoity1366183dacoity
dakoity1543423dakoity
entity9312053ent_ity
equity1838103_equity
facility1638253facility
facticity1945963facticity
factuality1843863factuality
faggoty1542863faggoty
fairy115318283fa__iry
faith115620853fa__ith
fajita1635923fa_jita
falsify1643613falsify
family143311703fa_mily
fancify1834983fancify
fancily1538253fancily
faquir1834313faqui_r
faquirs1943863faquirs
fatally1339893fatally
fatbird1344033fatbird
fating105328673fat_ing
fatlike142911193fatlike
fatling113815683fatling
fatly115716803fat__ly
fattier103513463fattier
fatties103018203fatties
fatting113818703fatting
fattish1359263fattish
fatuities1246913fatuities
fatuous1037783fatuous
fault85428313fa_ult_
faults94513553fa_ults
ferity122813343f_erity
fetidity1545863fetidity
fixity19427813f_ixity
flaunty1354413flaunty
fluty114415643f_lu_ty
fruit85122223f_ruit_
fruits94512493f_ruits
furmity1535193furmity
fusty115016523f__usty
futility1446983futility
gaseity1135113gaseity
intuit6314083intuit_
intuits7310313intuits
jaunty16388513ja_unty
laity85318903la__ity
latinity1138813latinity
laxity1637273la_xity
natality1139193natality
nativity1446643nativity
nattily103610323nattily
natty85719143nat__ty
obtusity1343693obtusity
outcity1238453outcity
outpity1237493outpity
parity114719873pa_rity
patty104723613pat__ty
paucity1435823paucity
rabbity14266303rabbity
rarity93615493ra_rity
ratify122610043rat_ify
ratite65022423rat_ite
ratty84819593rat__ty
raucity1235853raucity
sanity9316203sa_nity
satiety1038203satiety
satiny93817983sat_iny
tattily10409993tattily
tatty84720183tat__ty
tenuity1037453tenuity
tufty114810413__tufty
tutty85217023__tutty
vanity12311943va_nity
varsity1356673varsity
vastity1336203vastity
vaulty12388443va_ulty
vaunty12409063va_unty
viduity1445353viduity

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271026.25321434.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.68626726.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.