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

59 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
prelimit125912(None) 
prelimits1366011prelimits
delimit10311732_delimit
preadmit1346812preadmit
prelim10311432prelim__
prelimited1545492prelimited
prelims1139822prelim_s
previsit13410082previsit
delimits1137573_delimits
elicit8417203__elicit
limit73126343___limit
pelitic111814653p_elitic
pelmet103419243p_el_met
perlitic12310583perlitic
permit10321683p_e_rmit
preadmits1444923preadmits
preaudit1177023preaudit
precinct1459423precinct
predict12315323predi_ct
preedit10512463pre_edit
preemie11310563pre_emie
preempt1337723pre_empt
prefight1746393prefight
preflight1844673preflight
prelatic12311293prelatic
prelect111013833prel_ect
prelife1279953preli_fe
prelimiting1645383prelimiting
prelives13310383prelives
premie103617993pre__mie
premix173710333pre__mix
premixt183510663premi_xt
preriot9316413preri_ot
presidia1147273presidia
presidio1146153presidio
presift12312223presi_ft
presplit1247753presplit
presummit1553133presummit
preterit10315853preterit
pretermit1347133pretermit
previsits1446803previsits
primi95017403pr__imi_
prohibit1547193prohibit
prolamin12139753prolamin
prolific1546743prolific
prolixity2144863prolixity
proximity2344673proximity
pyelitic1547593pyelitic
pyelitis1346583pyelitis
readmit1039823_readmit
reemit8717223_re_emit
reliant7319243_reliant
relict83623903_reli_ct
relight11512063_relight
relist64628413_reli_st
relit55340683_rel__it
remit75737223_re__mit
revisit10311383_revisit
sublimit1247513sublimit

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 Filter1786911461620.440406115.9
2DLD Change Limit146162597.54619369.5
3Display Results59590.0301966.7
 (SQL Overall)178691598.01622291.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.