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

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

69 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
unserviceable206207(None) 
serviceable1852402__serviceable
disserviceable2211803disserviceable
serviceably2152003__serviceably
unenviable1545854un_envi__able
unnoticeable1652874un_noticeable
unpredictable2052954unpredictable
unreviewable2052604unre_viewable
unsalvageable1961414unsalvageable
unsearchable1953404unse_archable
unseeable1149454unse____eable
untraceable1546854un_tr_aceable
unverifiable2053284unver_ifiable
enforceable1852785enfor__ceable
ineffaceable2252425in_effaceable
ineradicable1754285in_eradic_able
inevitable1557645in_e_vi_table
inheritable1647245inher_i_table
interminable1656895intermi_nable
intervisible1753925intervi_sible
noticeable1443715_n__oticeable
observable1743345observ___able
priceable1546825___pr_iceable
reservable1546375reserv___able
servable13310095__serv___able
sliceable1345445__s__liceable
survivable1842955__survi_vable
unbelievable1952845unbe_lievable
unbreachable2153415un_breachable
unbridgeable18131915un_bridgeable
uncorrectable1963395uncorrectable
undanceable1654405un__danceable
undecidable1745725unde_ci_dable
undefinable1746385unde_fi_nable
undeliverable1962065undeliverable
undeniable1348565unde_ni__able
undesirable1447485unde_si_rable
undetectable1754575unde_tectable
undrinkable1853575un_dr_inkable
uneducable1545785un_e_duc_able
unelectable1546755un_e_lectable
unenforceable2061605unenforceable
unexcitable2245065un_exci_table
unforeseeable1861525unforeseeable
unforgivable2152455unforgi_vable
unmentionable1753675unmentionable
unobservable1953135unobserv___able
unperformable2262435unperformable
unpredictables2161295unpredictables
unpredictably2362255unpredictably
unprintable1555215un_pr_intable
unreachable1846095un__reachable
unrealizable2354305unreali_zable
unrecyclable2152895unre_cyclable
unreliable1248485unre_li__able
unrespectable1953525unrespectable
unridable1248295un__r_i_dable
unsearchably2252495unse_archably
unseasonable1454265unse_asonable
unsellable1247095unse___llable
unshockable2253145uns__hockable
unsinkable1645095uns___inkable
unsociable1447285uns___ociable
unsolvable1545085unsolv___able
unspecifiable2262315unspecifiable
unsuitable1247575uns__ui_table
unsurpassable1771525unsurpassable
unteachable1845745unte__achable
unviable1338705un___vi__able

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790699.12613674.1
3Display Results69690.0461500.0
 (SQL Overall)178691699.56218687.6
 
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.