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

99 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
straying122912691straying
estraying1338292estraying
spraying14299882spraying
staying114017322st_aying
strafing122111192strafing
strain64919572stra_in_
strains74218152stra_ins
strawing122411622strawing
stroying122410592stroying
arraying1238753arraying
atrazine1748403atrazine
betraying1537713betraying
braying134416313_braying
draying123813843_draying
foraying1537433foraying
fraying143413433_fraying
graying124115883_graying
grayish1437813_grayish
praying133717323_praying
raying105027193__raying
saying104325543s__aying
scraich1436763scra_ich
scraigh1335673scra_igh
scraping133310863scraping
scrying1338663scr_ying
serrying12167693serrying
slaying113316843s_laying
spaying133014623s_paying
splaying14219303splaying
sprain83614863spra_in_
sprains93013593spra_ins
staging93818373st_aging
stain55727943st_a_in_
stains64923653st_a_ins
staking123919803st_aking
staling83925423st_aling
stamina9310793st_amina
stanine73417073st_anine
staning83922243st_aning
starfish1438083starfish
staring84527053st_aring
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
statin63921473st_atin_
stating83725163st_ating
statins73719773st_atins
staving113915703st_aving
steading103613593steading
steadying14154503steadying
stealing93416603stealing
steaming114013213steaming
stearin7312003stearin_
stearine8311903stearine
stearins8312143stearins
stimying1437503stimying
storying12249673storying
straight1249183stra_ight
strained9412253stra_ined
strainer8512223stra_iner
straining10410563straining
strait64025893stra_i_t
straits74916323stra_its
stramash1344573stramash
stramony1344933stramony
strand74514823stra__nd
stranding1149653stranding
strang75718313stra__ng
strapping1436993strapping
strath93216373stra__th
strati63518903strati__
stratify1445703stratify
strawier1137493strawier
stray88525573stray___
strayed114513283stray_ed
strayer104312503stray_er
strayers113510143strayers
strays96417933stray__s
streaking142010323streaking
streaming12239653streaming
strewing12289853strewing
striating10914193striating
striding102713603striding
striking133012233striking
string75327563str__ing
striping112612523striping
striving122611393striving
stroking132610943stroking
strowing122310563strowing
studying1335553studying
stying105414573st__ying
stymying1733963stymying
swaying143610643s_waying
tracing103720153_tracing
trading93517973_trading
train56529113_tra_in_
trains64725343_tra_ins
trying104214073_tr_ying

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 Filter1786911461620.423422437.4
2DLD Change Limit146162996.75021653.6
3Display Results99990.0303300.0
 (SQL Overall)178691997.20324807.9
 
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.