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

56 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
precheck214415(None) 
prechecks2243571prechecks
recheck1835611_recheck
forecheck2342772forecheck
paycheck2442552paycheck
pincheck2143382pincheck
prechecked2443082prechecked
rechecks1944552_rechecks
aircheck1942903aircheck
check164714713___check
creche13310763creche__
creches14313093creche_s
crewneck1942123crewneck
forechecks2462523forechecks
hatcheck2244013hatcheck
paychecks2542243paychecks
peched144915343p_eche_d
perched154713243perche_d
percher143313423perche_r
perchers153611523perchers
perches143717953perche_s
pinchbeck2451913pinchbeck
pinchecks2243153pinchecks
preached163412063preache_d
preacher153211373preache_r
preachers16339573preachers
preaches153214893preache_s
precede1239653prec_ede
precent113520263prec_ent
precept133112513prec_ept
precess11310863prec_ess
prechecking2543073prechecking
prechill1546193prechill
prechose15129773prechose
precieux1943033precieux
precinct1459423precinct
preclean1245893preclean
preclear1245423preclear
precook1577803prec_ook
preelect1249643preelect
preerect1259273preerect
prefect141011073pre_fect
preheat12413893pre_heat
prelect111013833pre_lect
prepack1757643pre_pack
prerock1536723pre_rock
prochein1547523prochein
prophecy2043913prophecy
rebeck14419913_re_beck
recheat12415933_recheat
rechecked2143973_rechecked
rechew14310213_reche_w
rechews1537293_rechews
recock145112723_rec_ock
redneck1445113_redneck
sidecheck2151773sidecheck

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.500357382.0
2DLD Change Limit146162567.75018859.6
3Display Results56560.0163500.0
 (SQL Overall)178691568.26621617.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.