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

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

48 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
prearranging165265(None) 
rearranging1343781_rearranging
arranging1156303___arranging
disarranging1573123disarranging
overarranging1862613overarranging
prearrange1353213prearrang__e
prearranged1552703prearrang_ed
prearranges1453043prearrang_es
prefranking2143313pre_franking
barraging1337384__barra_ging
deranging1238064_de__ranging
estranging1246024__estranging
overhanging1946324ove_rhanging
paperhanging2151594paperhanging
pranging123012724p____ranging
preadapting1743654prea_dapting
prearming14139224prea_r__ming
prearrangement1971864prearrangement
preassigning1652924preassigning
preattuning1443044preattun_ing
precharging2043754pre_charging
precleaning1644264preclean_ing
precreasing1645704precrea_sing
prefinancing2051944prefinancing
prehardening1952584preharden_ing
preordaining1652514preordaining
prepackaging2451504prepacka_ging
preplanning1643694pre_planning
preplanting1645924pre_planting
preprinting1647414pre_printing
prerinsing1347644pre__rinsing
presaging1339394pre__sa_ging
preshrinking2252444preshrinking
pretraining1446504pre_training
pretreating1448894pretrea_ting
prewarning16135194prewar_n_ing
preweaning1645634pre_wean_ing
prewrapping1842394pre_wrapping
rearrange1045034_rearrang__e
rearranged1244104_rearrang_ed
rearranges1145114_rearrang_es
rearresting1245964_rearresting
rechanging1746044_re_changing
regranting1238324_re_granting
rehanging1437564_re__hanging
respringing1544584_respringing
restringing1345714_restringing
warranting1444744__warranting

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 Filter1786911247900.1431249587.4
2DLD Change Limit124790487.95315690.9
3Display Results48480.0301600.0
 (SQL Overall)178691488.12621990.0
 
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.