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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

61 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
unchaster144539(None) 
unchaste1346921unchaste_
chaster124718502__chaster
enchanter1446192enchanter
enchaser1346692enchas_er
uncharted1538082uncharted
unchastely1852722unchastely
unchastest1543422unchastest
caster85232573__c_aster
chanter123919733__chanter
chapter144213853__chapter
charter123918303__charter
chaser114918383__chas_er
chaste114617393__chaste_
chasten124312403__chasten
chatter124416643__chatter
coaster94219043__coaster
enchanted1546553enchanted
enchanters1545223enchanters
enchase1239463enchas_e_
enchased1437383enchas_ed
enchasers1445093enchas_ers
enchases13310273enchas_es
purchaser1643373purchas_er
recharter1466893recharter
subchapter1952373subchapter
subchaser1644313subchas_er
unbasted112510073un_basted
uncarted11312053unc_arted
uncase83817433unc_as_e_
uncased104216953unc_as_ed
uncases93516553unc_as_es
uncashed14299763unc_ashed
uncasked15278453unc_asked
uncast84215713unc_ast__
unchained1537273unchained
unchair1236163uncha__ir
unchaired1536203unchaired
unchanged1636283unchanged
uncharge1446313uncharge_
uncharged1636613uncharged
uncharges1546213uncharges
uncharred1536103uncharred
unchartered1742833unchartered
unchastity1852073unchastity
unchosen1356283unchos_en
unclasped1465503unclasped
unclutter1143373unclutter
uncoated11314963uncoa_ted
uncrate9415953uncra_te_
uncrated11416313uncra_ted
uncrates10314563uncra_tes
uneasier836963un_easier
unfasten1144843un_fasten
unhairer11174993un_hairer
unhasty1344283un_hast_y
unhatted1238183un_hatted
unmasker14245023un_masker
unroasted1036613unroasted
untasted92011573un_tasted
unwasted12259783un_wasted

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 Filter1786911486410.423422437.4
2DLD Change Limit148641616.79621871.8
3Display Results61610.0302033.3
 (SQL Overall)178691617.24924650.4
 
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.