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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 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
entrust741088(None) 
encrust947871encrust
entrusts847111entrusts
intrust7311491intrust
antirust8411172antirust
centrist10314862centrist
encrusts1045282encrusts
enthuse1046962enthuse
entrant7318872entrant
entreat7315262entreat
entrusted1065942entrusted
entwist1048802entwist
estrus61912112estrus_
incrust949202incrust
intrusts837722intrusts
trust55426852__trust
unitrust845562unitrust
untruest847782untruest
untruss736552untruss
untrusty1144222untrusty
altruist857953altruist
antirusts948143antirusts
antitrust946363antitrust
antres65021003antres_
antrum8611313antru_m
antrums969173antrums
becrust1137983becrust
centres93817123centres_
centrism1249643centrism
centrists11410233centrists
centrum1168603centru_m
centrums1236913centrums
citrus83610923citrus_
citrusy12284183citrusy
contrast102614783contrast
crust75827663__crust
dentist8316743dent_ist
denturist1048463denturist
destruct1148383destruct
distrust949943distrust
ecrus75113863e_crus_
encrusted12125003encrusted
encrypt1445323encrypt
encyst1136203en_cyst
endmost1056763endmost
englut738453englu_t
engluts834533engluts
engraft11118613engraft
engross837123engross
enlist6417043en_list
enrapt8313013en_rapt
enroot6615993en_root
enters64425643enters_
enthused1245083enthused
enthuses1138253enthuses
entires71517783entires_
entrain7313073entrain
entrants8311753entrants
entrap8710563entr_ap
entraps9109763entraps
entreats839773entreats
entreaty1146173entreaty
entree61817883entr_ee
entrees71813773entrees
entrepot1046193entrepot
entresol844363entresol
entries71523163entries
entropy1247353entropy
entrusting11126183entrusting
entry82414263entr__y
entwists1156143entwists
enures63919713enures_
erst47436433e__r_st
eruct74022353e__ruct
erupt74220063e__rupt
estreat7314813estreat
estrous7712533estrous_
estrual7367933estrual
estrum81810513estru_m
estrums9208603estrums
estruses838483estruses
exhaust1744243exhaust
extract16311013extract
extras13310223extras_
extrude1545013extrude
gentlest93410573gentlest
inburst937163inburst
incrusts1036253incrusts
inrush936513in_rush
instruct1047543instruct
interest8319183interest
intrant7318753intrant
intreat7416303intreat
introit7414533introit
intros64215773intros_
intrude837403intrude
intrusted1076903intrusted
intuit6314083int_uit
intwist1038043intwist
metrist9317063metrist
mistrust1049203mistrust
nearest73415843nearest
oestrus7169583oestrus_
onrush935343on_rush
outrush1037043outrush
rust45544913___rust
strunt64918913_strunt
strut56030733_stru_t
struts65616803_struts
tenorist8413023tenorist
tentiest82115613tentiest
thrust91911893_thrust
truest64816193__truest
truss54916923__truss
trusts64714433__trusts
trusty94710113__trusty
tryst84716223__tryst
undrest8313013undrest
unitrusts943323unitrusts
unjust1337873un_just
unrest62918853un_rest
untrue6310773untru_e
untruer737113untruer
untruly1046293untruly
untruth1045353untruth
untwist1047713untwist
upthrust1343713upthrust

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271276.31321230.3
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.77926359.5
 
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.