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

155 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
subtiler1020856(None) 
subtile91912611subtile_
subtler92910841subt_ler
subfile122010502subfile_
subfiles131710712subfiles
sublimer1237602sublimer
subsider1138242subsider
subsoiler1145322subsoiler
subtilely1444942subtilely
subtilest1148802subtilest
subtilin1047112subtilin
subtilty1345452subtilty
subtitle1046582subtitle_
subtitled1244692subtitled
subtitles1156822subtitles
subtle82113432subt_le_
sutler63718392su_t_ler
auntlier834903auntlier
bailer85425253__bailer
boiler84319273__boiler
bubbler103611783bub_bler
bubblier1184473bubblier
bustier93916153busti_er
bustler94012563bust_ler
butler84220033bu_t_ler
curtailer1143823curtailer
cutler84718033cu_t_ler
ductile1048473ductile_
dustier83814133dusti_er
fubsier12367763fubsi_er
fustier104213933fusti_er
futile93914953fu_tile_
gustier83813863gusti_er
guttier83911103gutti_er
guttler8369163gu_ttler
hustler103410753hust_ler
jubile152910253jub_ile_
jubilee16298293jub_ilee
jubiles16289373jub_iles
lustier73813503lusti_er
mustier94017953musti_er
nubbier11308133nubbi_er
nubblier1254413nubblier
nubile83212703nub_ile_
nuttier73112023nutti_er
outlier72216143ou_tlier
purtier93214093purti_er
puttier93314503putti_er
rubblier1244913rubblier
rubier84814733rub_i_er
runtier73512853runti_er
rustier74416363rusti_er
rustler73512343rust_ler
rutile65217683ru_tile_
rutiles74315843ru_tiles
ruttier73412283rutti_er
sailer63526103s__ailer
saltier74318633salti_er
sectile9311973sectile_
settler73410653s_ettler
sextile1438573sextile_
sextiles1537643sextiles
shuttler1164893shuttler
siltier73413863silti_er
slatier74016813slati_er
sluttier836453slutti_er
smiler83916683s__miler
smuttier1035213smutti_er
snubbier1244993snubbi_er
sootier73916603sooti_er
spoiler93310683s_poiler
staler64025823s__taler
stifler102911463s__tifler
stile54931573s__tile_
stiles64328763s__tiles
stiller73414283s__tiller
stiver93915733s__tiver
stubbier1235353stubbi_er
stubblier1343203stubblier
styler94013303s__tyler
subalar9118073sub_alar
subclerk1643793sub_clerk
subdealer1245223subdealer
subduer10107033sub_duer
suber74924503sub___er
subfield1444753subfield
subfixes20207493subfixes
subidea1037533sub_idea
subitem1138543sub_item
sublet82827243sub__let
sublime11310353sublime_
sublimed1337203sublimed
sublimers1345773sublimers
sublimes12310023sublimes
subline9316893subline_
sublines10315783sublines
submitter1345263submitter
suborder1146663suborder
suborner1047383suborner
subpolar1245183subpolar
subrule939643subrule_
subrules1039723subrules
subsale9310543subsale_
subsales10310123subsales
subside10410453subside_
subsided1257643subsided
subsiders1246043subsiders
subsides11410823subsides
subsister1145973subsister
subsite9412863subsite_
subsites10312763subsites
subsoiled1245433subsoiled
subsoilers1244053subsoilers
subsolar1045113subsolar
subteen938523subt_een
subtilins1147163subtilins
subtility1446593subtility
subtilize2087123subtilize
subtilized2246123subtilized
subtilizes2166863subtilizes
subtilties1246093subtilties
subtlest10511353subt_lest
subtlety1345063subt_lety
subtly11249263subt_l_y
subtone9310343subtone_
subtones10311373subtones
subtribe1246453subtribe_
subtribes1346223subtribes
subtype1444203subtype_
subtypes1544553subtypes
subvicar1544583subvicar
subwriter1445623subwriter
suckier133613973sucki_er
suckler133413093su_ckler
sudsier868773sudsi_er
sufficer16225823sufficer
suiter64121813su__iter
sulkier113811963sulki_er
sultrier837773sultrier
sunnier73412153sunni_er
suppler1148433su_ppler
supplier1246603supplier
surfier102613543surfi_er
surlier72915443surli_er
surmiser1036763surmiser
surtitle845283surtitle_
surtitles945633surtitles
surviver1434683surviver
sustainer944783sustainer
sutlers73116973su_t_lers
tiler56131023___tiler
tubbier11237743tubbi_er
tuftier1096603tufti_er
turtler72610323turt_ler
utile54718933_u_tile_

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.1731032896.0
2DLD Change Limit1461621557.14020470.9
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.37624226.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.