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

106 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
untidies93981(None) 
untidied1038901untidied
untidier946781untidier
untidiest1046031untidiest
entities8617412entities
tidies74721832__tidies
undies73821962un__dies
unifies102714712un_ifies
unities72520152un_ities
untidily1245872untidily
untidiness1155672untidiness
unties64326922unt__ies
accidies1338043accidies
antibias10312083antibias
antibodies1346983antibodies
antidotes1049533antidotes
antiques1738883antiques
aunties73920073aunt__ies
betides104915263betid_es
citifies13310683citifies
custodies1245963custodies
cytidines1544803cytidines
didies84621833__didies
enmities10611353enmities
entices91616333enti_ces
entires71517783enti_res
entitles8710663entitles
entries71523163ent_ries
indies73822783in__dies
insides8512653insid_es
intines7921113inti_nes
intitles8710003intitles
justifies1945793justifies
mutinies10311503mutinies
neddies92710703_neddies
nides65229133_n_id_es
nixies135313873_n_ixies
noddies93512043_noddies
notifies11310423notifies
nudies75217093_n_udies
nudities939683nudities
ploidies1138173ploidies
punties94520783punt__ies
quantifies2244753quantifies
quantities1946293quantities
ratifies11313513ratifies
stimies9316563_stimies
studies82413863_studies
subsidies1248423subsidies
tantivies1247103tantivies
tides64830153__tid_es
tidied83613273__tidied
tidier73515113__tidier
tidiers8389773__tidiers
tidiest83514873__tidiest
todies74223553__todies
uglifies1246383uglifies
unaided92414603unaid_ed
unbidden1263573unbidden
unbodied1237263unbodied
unbridles1244133unbridles
undines8716083undi_nes
undoes73917403un__does
unfixes17238113unfi_xes
unhinges12266723unhinges
unified112413573un_ified
unifier102211863un_ifier
unifiers11237173un_ifiers
uniques1667443un_iques
unitages938273unitages
unites65024853un_i_tes
unitizes1739133unitizes
unlades82612833unlad_es
unlives102010953unli_ves
unmitres1036863unmitres
unmixes16197753unmi_xes
unpiles92112783unpi_les
unpitied1138793unpitied
unriddles1143503unriddles
unsteadies1154153unsteadies
unstudied1194283unstudied
untidy1059153untid__y
untidying1445473untidying
untie54425493unt__ie_
untied73720813unt__ied
untieing938863untieing
untilled9710563untilled
untilted9610893untilted
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untiring9312003untiring
untitled978763untitled
untried82615853unt_ried
untrims938613unt_rims
untunes72211253unt_unes
untwines1137603untwines
unwishes14147483unwishes
upsides10319633upsid_es
uptimes1177553upti_mes
ureides8311103ureid_es
uridines989513u_ridines
utilise749063u_tilise
utilises848973u_tilises
utilizes1758123u_tilizes

Search took 9 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621068.40617387.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.62220725.0
 
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.