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

110 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
seagirt831015(None) 
begirt9412682be_girt
engirt71112612_engirt
seabird1055362seabird
sealift10312792sealift
seaport9315602seaport
agist66325583__agist
airt45757783__a_irt
begird1036823be_gird
deair65817193dea_ir_
deairs74013783dea_irs
eager65526973_eager_
eagers74523683_eagers
eaglet73722583_eaglet
eagre64315323_eag_re
engird8126973_engird
girt56646423___girt
heart85440743hea__rt
hegira1036523he_gira
imagist1077333imagist
legist71315253le_gist
legit61323503le_gi_t
meager94515203meager_
meagre9349323meag_re
overgirt1239123overgirt
peart76440753pea__rt
reagent8716603reagent
reagin74915533reagi_n
reagins84215643reagins
realist73225383realist
regilt71217493re_gilt
sabir75917003s_abir_
sabirs85414633s_abirs
sadist74221353s_adist
sagbut959753s_agbut
sager65432053s_ager_
sagest74920263s_agest
sagier73717163s_agier
sagiest82617983s_agiest
saint55147073s_a_int
satire63218003s_atire
scart76139773sca__rt
seabirds1164403seabirds
seaboot9512333seaboot
seagoing1038193seagoing
seagull843933seagull
sealant73118303sealant
sealer63928963sealer_
sealers74323553sealers
sealery104011053sealery
sealifts1135473sealifts
sealing83528563sealing
seamark1336723seamark
seamer84223613seamer_
seamers94719433seamers
seamier93114633seamier
seamiest102715413seamiest
seaming103222113seaming
seaports1038463seaports
sear47353843sea__r_
searer65432023searer_
searest73322023searest
searing83330923searing
sears54744913sea__rs
seasick1346193seasick
seaside839693seaside
seat47575563sea___t
seater64534163seater_
seaters74028943seaters
seating84130683seating
seawant103613413seawant
seaward1148183seaward
seaware1049633seaware
sedgier9399053sedgier
sedgiest10259763sedgiest
seggar8357813seggar_
seggars9377783seggars
sengi64016513sengi__
sennit63117923senni_t
serger73819743serger_
sergers83815633sergers
serging93416673serging
sexist133013483se_xist
shaird10288703sha_ird
shairn9269063sha_irn
shirt84533903s__hirt
skirt95624663s__kirt
smart75834093sma__rt
spait75631603spa_i_t
spaviet123011923spaviet
spirt75032953s__pirt
squirt153812933s_quirt
stager74821343stager_
stagers84116673stagers
staggart1046643staggart
stagier83513443stagier
stagiest91613403stagiest
stagily1139053stagily
staging93818373staging
stair54719943sta_ir_
stairs65416333sta_irs
start55642313sta__rt
statist7317723statist
swager104013613swager_
swagers114211023swagers
swaging124210633swaging
swart86234643swa__rt
teacart91113193teacart
ungirt71112713_ungirt
upgirt9117263_upgirt

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271107.45317983.0
3Display Results1101100.0333333.3
 (SQL Overall)1786911107.89222642.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.