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

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

51 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
reconnoitering176164(None) 
reconnoitring1672101reconnoit_ring
reconnoiter1373003reconnoiter___
reconnoitered1661493reconnoiter_ed
reconnoiters1462033reconnoiter__s
reconsidering1752323reco_nsidering
reconfiguring2061634reco_nfiguring
reconnecting1745354reconnect__ing
reconnoitre1362314reconnoit_r__e
reconnoitred1562004reconnoit_r_ed
reconnoitres1452324reconnoit_r_es
reconquering2452994reco_n_quering
reconstituting1763234reconstituting
recontouring1553254reconto__uring
rencountering16122474rencoun__tering
concentering1755445__concentering
connoting12310025__conno_t__ing
considering1544845__co_nsidering
countering13314475__coun__tering
decentering1546485dec_en__tering
encountering1583135encoun__tering
recensoring1444675recenso___ring
rechartering1853545rec__hartering
recognising1544545recogn_i__sing
recognizing2445695recogn_i__zing
recolonizing2455365recoloni__zing
recoloring1367585reco_lo___ring
recommitting1954135reco_mmit_ting
reconceiving2093455reconcei__ving
reconciling1645485reco_nci__ling
reconditioning1872515reco_nditioning
reconducting1854725reconduct__ing
reconferring1853725reco_n_ferring
reconfining1745115reco_nfi__ning
reconfirming2053085reco_nfi_rming
reconning121410795reconn_____ing
reconsigning1653445reco_nsi_gning
reconsolidating1962015reconsolidating
reconsoling1444485reconso___ling
reconsulting1554215reconsult__ing
recontacting1745065recontact__ing
reconvening1746295reco_n__vening
reconverting1876405reco_n__verting
reconveying2044635reco_n__veying
reconvicting20114625reco_nvi_cting
reconvincing2053165reco_nvi_ncing
recounting1339195recoun__t__ing
recovering1647375rec___o_vering
reembroidering206885reembroidering
reencountering1791375re_encountering
reentering1149985re__en__tering

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 Filter178691950240.360496363.9
2DLD Change Limit95024516.84313886.3
3Display Results51510.0301700.0
 (SQL Overall)178691517.23324705.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.