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

52 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
rejackets226298(None) 
rejacket2166731rejacket_
jackets205011372__jackets
rackets134916872r__ackets
rejacketed2442272rejacketed
remarkets15224992remarkets
beckets15399823be__ckets
bluejackets265823bluejackets
brackets163310433_brackets
hijackers2542323hijackers
jackers204214453__jackers
jacket194720673__jacket_
packets155114773__packets
plackets1646583_plackets
premarkets1863633premarkets
rachets124516833r__achets
rackers134320453r__ackers
racket125229423r__acket_
rackety16499113r__ackety
reaccents1365853re_accents
reaccepts1583213re_accepts
reachers133515723re_achers
reaches123423203re_ache_s
reacts83616603re_ac__ts
recarpets1344383recarpets
redacts10510943redac__ts
refaces123216743refac_e_s
rejacketing2542413rejacketing
rejectees18235423rejectees
rejecters18257543rejecters
rejects163910693rejec__ts
relaces93420883relac_e_s
remakers143811303rema_kers
remakes134116173rema_ke_s
remarkers15197283remarkers
remarket142111033remarket_
repacked17188743repacke_d
repacks15269543repack__s
reracked15169123reracke_d
reracks132310533rerack__s
retacked15169273retacke_d
retackles1545363retackles
retacks132210713retack__s
retakers123511133reta_kers
retakes113718863reta_ke_s
retargets1045303retargets
rewakens15406243rewa_kens
rewakes144614983rewa_ke_s
rickets134915093r__ickets
rockets134615363r__ockets
tackets134914363__tackets
trebuckets1891753trebuckets

Search took 7 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.420425454.8
2DLD Change Limit148641526.36023371.2
3Display Results52520.0163250.0
 (SQL Overall)178691526.79626293.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.