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

100 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
unstrap94678(None) 
unstraps1045981unstraps
entrap8710562en_trap
strap77925262__strap
unsharp1235542unsharp
unsnap836202uns_nap
unstep839222unst_ep
unstop837472unst_op
unwrap11126322un_wrap
antra56521923an_tra_
antral65719413an_tral
astral66919283_astral
astray95615543_astray
austral73411513austral
caltrap11297943caltrap
cantrap113310283cantrap
chinstrap1652613chinstrap
dustrag945363dustrag
entraps9109763en_traps
enwrap1185213en_wrap
estral64716513_estral
estray95713333_estray
flytrap1543253flytrap
gastral8329553gastral
instal6712193inst_al
instar6310013inst_ar
instars7411133instars
instead836203instead
instep838193inst_ep
inwrap11115903in_wrap
lustra6358893lustra_
lustral7339653lustral
mantrap11379823mantrap
mistral91013643mistral
onstream1045113onstream
outstrip1045083outstrip
rattrap945263rattrap
ristra6310713ristra_
ristras7311563ristras
rostra6310933rostra_
rostral7311333rostral
satrap86212553_satrap
scrap97120403__scrap
sistra639333sistra_
straps87721783__straps
straw813321293__straw
stray88525573__stray
strep77120853__strep
strip77524343__strip
strop77422243__strop
trap67532803___trap
ultra539363u_ltra_
ultras6310193u_ltras
uncap9312283un__cap
underlap11146423underlap
undrape1049333un_drape
undraw1037813un_draw
unitard838003unitard
unitary1038613unitary
unmoral948693unmoral
unrip72012863un__rip
unsay83212843uns__ay
unscrew1245463unscrew
unseal63315473uns_eal
unseam83313143uns_eam
unseat64221023uns_eat
unship1148033uns_hip
unsmart939603unsmart
unsnag736393uns_nag
unsnaps935423uns_naps
unsnarl7107153unsnarl
unspeak1344793unspeak
unstack1337373unstack
unstate71916213unstate
unsteady1243513unsteady
unsteel738793unsteel
unsteps936213unsteps
unstick1338123unstick
unstops936993unstops
unstrapped1573563unstrapped
unstress837373unstress
unstring9312093unstring
unstriped1246303unstriped
unstrung954653unstrung
unstuck1345023unstuck
unstung834853unstung
unsure62815413unsur_e
unswear1035003unswear
untrack1338703un_track
untread857413un_tread
untrim8310683un_trim
untrod769853un_trod
untrue6310773un_true
unwraps1255513un_wraps
upstare9158683upstare
upstart9159753upstart
upstep1035503upst_ep
upstream1243553upstream
usurp7106903u_sur_p
vestral104111013vestral

Search took 10 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.936190909.2
2DLD Change Limit1340271008.11016526.1
3Display Results1001000.0462173.9
 (SQL Overall)1786911009.09219653.7
 
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.