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

68 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
lionisers94417(None) 
lioniser845581lioniser_
lionises8310311lionise_s
lionizers1844241lionizers
ionises72916432_ionise_s
ionizers17257712_ionizers
lionise7310372lionise__
lionised946602lionise_d
lionizer1756052lionizer_
lionizes1738772lionize_s
adonises92611433adonise_s
agonises92613163agonise_s
atomisers11255453atomisers
conifers133611703_conifers
deionizers2053973deionizers
ebonises1039223ebonise_s
finises10312903fi_nise_s
finishers1545353fi_nishers
idolisers1043703idolisers
igniters9126233_igniters
iodises83413633_iodise_s
iodizers18316123_iodizers
ionise63516943_ionise__
ionised82911493_ionise_d
ionizer162310123_ionizer_
ionizes162813343_ionize_s
ionomers1038503_ionomers
liaises7311053li_aise_s
licensers11114583licensers
lignites9129613lignite_s
limiters10249333li_miters
limners93311563limn__ers
limonites1148003limonite_s
liners65428853li_n__ers
lingers84223303li_n_gers
linier64423793li_ni_er_
linkers114317713li_n_kers
linseys1035083li_n_seys
linters73822633li_n_ters
lioness739103lion__ess
lionesses939433lionesses
lionfishes1643543lionfishes
lionising1046463lionising
lionize1668823lionize__
lionized1837023lionize_d
liviers104211073li_vi_ers
loiters74116613l_o_iters
loners64225813l_on__ers
longers84819543l_on_gers
loonier73312683looni_er_
loonies73919543looni_e_s
looniness9137573looniness
lorimers1036613l_orimers
loriners839963l_oriners
lorises73918593l_orise_s
losers65123583l_o__sers
ministers1139623mi_nisters
minivers1337483mi_nivers
monikers1437413_monikers
nonusers8268003_nonusers
ozonises1776373ozonise_s
ozonizers1753233ozonizers
pioneers1035863pion_eers
poisers94214433_po_isers
promisers13268203promisers
rinsers73815743ri_n_sers
unionises947163unionise_s
unionizers1943013unionizers

Search took 9 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.1701051123.5
2DLD Change Limit148641687.90618801.0
3Display Results68680.0332060.6
 (SQL Overall)178691688.10922036.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.