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

101 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
unideal83710(None) 
ideal65716392__ideal
nidal65217102_nid_al
nonideal947302nonideal
undead82711902un_dead
unideaed1045732unideaed
unreal64414452un_real
unseal63315472un_seal
animal85016253ani_mal
anneal64812293an_neal
anodal72512123anod_al
bridal9511453brid_al
cnida878953cnid_a_
cnidae978143cnid_ae
conidial1159503conidial
cuneal8611513cun__eal
deal56347413___deal
endear74110013en_dear
epigeal1046243epigeal
funereal1143943funereal
gonidial1065943gonidial
idea59122773__idea_
ideals75012503__ideals
ideas65919013__ideas
ileal56118083__ileal
infidel1146043infide_l
initial7311883initial
lineal65616023_lineal
misdeal1037663misdeal
nide55535793_nide__
nided75920873_nide_d
nides65229133_nide_s
nival84915773_ni_val
nodal64717793_nod_al
nucleal946693nucleal
ordeal779253_ordeal
pineal84817683_pineal
seidel7311083seide_l
snide64318723snide__
snidely1136813snidely
snider74413913snide_r
snidest8310913snidest
snivel9368853snive_l
subidea1037533subidea_
subideas1146443subideas
sundial859863sun_dial
tidal64516443_tid_al
tineal66216163_tineal
unadept1046603unadept
unaided92414603unaide_d
unaidedly1443783unaidedly
unbear889163un_bear
uncial83715223un_cial
uncinal959963uncinal
unclean946973unclean
unclear936573unclear
unde55825483un_de__
undee65327273un_de_e
under64624213un_de_r
undies73821963undie_s
undraw1037813un_draw
unequal1644483unequal
unfilial1145343unfilial
ungual738183un_gual
unialgal942693unialgal
uniaxial1543883uniaxial
unilineal943923unilineal
unisex1358353unise_x
unisexual1652543unisexual
unisonal845373unisonal
unite54828383unite__
united74421543unite_d
unitedly1245793unitedly
uniter64619143unite_r
uniters73814173uniters
unites65024853unite_s
universal1243463universal
univocal1343663univocal
unlead73312373un_lead
unmoral948693unmoral
unread73412673un_read
unreel63612933un_reel
unseals73212583un_seals
unseam83313143un_seam
unseat64221023un_seat
unsell63512543un_sell
unshell1047113unshell
unspeak1344793unspeak
unsteel738793unsteel
unswear1035003unswear
untread857413untread
unusual743943unusual
unveil957343un_veil
unvocal1245233unvocal
unwell9349443un_well
ureal56722683u__real
uredial82910483uredial
urial54823023uri__al
urinal6614123uri_nal
uveal84411073u__veal
vineal94814743_vineal

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.406440125.6
2DLD Change Limit1340271016.33021173.3
3Display Results1011010.0303366.7
 (SQL Overall)1786911016.76626410.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.