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

113 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
unwarier113688(None) 
uneasier836962uneasier
unfairer11184282unfairer
unhairer11174992unhairer
unvaried1239682unvaried
unwariest1246032unwariest
unwarily1446362unwarily
unwarmed1437302unwarmed
unwarned1238452unwarned
unwarped1436872unwarped
unwearied1336762unwearied
warier93722892__warier
angaries9314393angaries
angrier839023an_grier
awarder1135893_awarder
blearier1037333blearier
charier124317903_charier
drearier9297923drearier
dwarfer1433683_dwarfer
enlarger944153enlarger
glarier84112203_glarier
gnarlier9255163gn_arlier
hoarier104211743_hoarier
hungrier1233893hun_grier
learier73415663_learier
nearer64618893_near_er
nearlier836793_nearlier
onerier7311613on_erier
rewarder12208233rewarder
scarier94017873_scarier
smearier1036953smearier
snakier112810003sn_akier
snarer64620843sn_ar_er
snarkier12336513sn_arkier
snarler73610633sn_arler
snarlier8278183sn_arlier
sneakier1245143sneakier
sneerier878103sneerier
sugarier937393sugarier
swarmer1247803_swarmer
tawdrier12133433tawdrier
tearier73815613_tearier
thwarter1433393thwarter
towerier1137123towerier
unaired82916013un_aired
unarmed101811923un_armed
unawarded1444923unawarded
unaware1038033unawar_e_
unawares1137053unawar_es
unbarbed13217753unbarbed
unbarred11238703unbarred
unburied11208513unburied
uncannier1144033uncannier
uncarded12310133uncarded
uncaring11312843uncaring
uncarted11312053uncarted
uncarved1438163uncarved
undaring10412753undaring
undried92314613un_dried
uneager839753unea_ger
unearned9310063unearned
unfair936233unfa_i_r
ungarbed12197063ungarbed
unhair937333unha_i_r
unhaired12238763unhaired
unhairers12183273unhairers
unhandier1344883unhandier
unhappier1642393unhappier
unharmed1438093unharmed
unharried1344763unharried
unholier1137283unholier
unifier102211863un_ifier
unmaker13279513unma_ker
unmanlier1144243unmanlier
unmarked15248813unmarked
unmarred11258403unmarred
unmarried1244583unmarried
unmasker14245023unmasker
unpacker16215893unpacker
unpaired11208943unpaired
unparted11310823unparted
unreadier1045013unreadier
unriper9188283un__riper
unrulier845333unrulier
untidier946783untidier
untried82615853un_tried
untruer737113un_truer
unwalled1288653unwalled
unwaning1238133unwaning
unwanted12249603unwanted
unwariness1365883unwariness
unwarlike1652883unwarlike
unwary1239823unwar__y
unwashed15288483unwashed
unwasted12259783unwasted
unwaxed18308393unwa_xed
unwinder1235613unwinder
unwiser1037123unw_iser
unworked16238503unworked
unworried1344013unworried
unworthier16122483unworthier
varier94619353__varier
wanier93920683__wanier
warder104020273__warder
warmer113816733__warmer
warner93717223__warner
warper114015583__warper
wartier103413913__wartier
wavier124613083__wavier
waxier16439903__waxier
wearier103613283_wearier
wirier94215553__wirier
wrier84521753__w_rier

Search took 8 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.576310227.4
2DLD Change Limit1461621137.31319986.6
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.93522519.3
 
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.