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

100 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
unjointed175558(None) 
unjoined16248441unjoin_ed
unpointed1237151unpointed
anointed938342an_ointed
enjoined16215722enjoin_ed
jointed15378502__jointed
uncoined111813022uncoin_ed
uncounted1238522uncounted
unjoint1449232unjoint__
unjoints1544432unjoint_s
unmounted1245902unmounted
unpainted1237182unpainted
unprinted1238132unprinted
unstinted1038562unstinted
untainted1038422untainted
unwonted12248642unwo_nted
adjoined1743513adjoin_ed
anointer837823an_ointer
appointed1444803appointed
arointed939003_arointed
cojoined1856293cojoin_ed
conjoined1965463conjoin_ed
disjointed1944833disjointed
enjoinder1742723enjoinder
enjoiner15225653enjoin_er
joined144613073__join_ed
jointer14379713__jointer
joisted15379173__joisted
outpointed1344313outpointed
pinpointed1542543pinpointed
pointed103813983__pointed
rejoined16318593rejoin_ed
subjoined1944233subjoin_ed
unbitted1138213un_bitted
unblinded13295233unblinded
unboiled112410373unboi_led
unbolted1179323unbo_lted
unbonded12299763unbo_nded
unboned103014223unbo_n_ed
unbonneted1343143unbonneted
unbooted1188773unbo_oted
unbounded1335413unbounded
uncoated11314963unco_ated
uncoiled112512683uncoi_led
undaunted1145453undaunted
undented102313953un_dented
undotted1048523undo_tted
undoubted1344463undoubted
unedited10249833unedi_ted
unfitted1238163un_fitted
unfoiled12249723unfoi_led
unfounded1435363unfounded
ungifted13116833un_gifted
ungowned1335183ungown_ed
unhinged13257473un_hinged
unionised1046533unionised
unionized1946673unionized
united74421543un__i_ted
unjointing1843963unjointing
unkinked12215903un_kinked
unknitted1443703unknitted
unlined82515803un_lin_ed
unlinked13237793un_linked
unlisted9311153un_listed
unlocated1238383unlocated
unmined102612953un_min_ed
unnoted8311363unno__ted
unoiled82415483un_oi_led
unowned1148813un_own_ed
unpinned1136383un_pinned
unpitted1148623un_pitted
unplanted1236853unplanted
unpoised1139183unpoi_sed
unposted1159433unpo_sted
unpotted11108393unpo_tted
unrented92413923un_rented
unrinsed938383un_rinsed
unroasted1036613unroasted
unrooted9810513unro_oted
unrounded1135863unrounded
unscented1237513unscented
unshifted16124943unshifted
unshirted13105953unshirted
unsifted12128773un_sifted
unsoiled92412083unsoi_led
unsorted9312513unso_rted
unsounded1135543unsounded
unsuited9310793unsui_ted
untented92613413un_tented
untilted9610893un_tilted
untinged10308943un_tinged
untwined1237063untwin_ed
untwisted1344863untwisted
ununited938683ununi_ted
unveined1258003unvein_ed
unvoiced14106303unvoi_ced
unwanted12249603un_wanted
unwitted1237543un_witted
unwounded1444623unwounded
unzoned172310653unzo_n_ed

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.436409841.7
2DLD Change Limit1486411007.00021234.4
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.48223882.8
 
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.