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

42 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
prebuilds144263(None) 
prebuild1344301prebuild_
rebuilds1143501_rebuilds
prebids12399882preb_i_ds
prebills1237292preb_ills
prebinds13357732preb_inds
preboils1267292preboil_s
prebuilt1247032prebuil_t
rebuild1036292_rebuild_
builds9378493___builds
misbuilds1442393misbuilds
outbuilds1243113outbuilds
overbuilds1642973overbuilds
piebalds1344343pieb_alds
prebends13347883preb_ends
prebid113512843preb_i_d_
prebill1138803preb_il_l
prebind123810643preb_ind_
preboards1446423preboards
preboil1148953preboil__
preboiled1455783preboiled
prebuilding1742383prebuilding
prebuys1444393prebu__ys
prechills1645123prechills
predrills1244473predrills
prefiles133113443pre_files
prefunds1454693prefu_nds
preguide1255423pregui_de
preguides1344863preguides
premolds1345843pre_molds
prequels1934833prequel_s
prescinds1444953prescinds
prevails1337663prevail_s
rebids94015533_reb_i_ds
rebills93510623_reb_ills
rebinds104511873_reb_inds
reboils94111723_reboil_s
rebuilded1342743_rebuilded
rebuilt939973_rebuil_t
regilds996673_re_gilds
unbuilds1143153_unbuilds
upbuilds1341753_upbuilds

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.423422437.4
2DLD Change Limit148641426.98321286.1
3Display Results42420.0162625.0
 (SQL Overall)178691427.42224075.9
 
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.