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

111 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
tailoring103640(None) 
tailorings1143431tailorings
retailoring1243732retailoring
taboring113010192ta_boring
tailing82923102tail__ing
tallowing1366292tallowing
trailering1145722trailering
adoring9412523_a_doring
ailing74331013_ail__ing
airing74927503_ai__ring
allowing12369093_allowing
alloying12339143_alloying
alluring939073_alluring
armoring1149123_armoring
bailing103723523bail__ing
balloting1238393balloting
coloring11414843_coloring
daikering1536103daikering
deploring1337853deploring
dialoging1246313dialoging
exploring1945543exploring
factoring1537533factoring
failing113521333fail__ing
fairing113614013fai__ring
fallowing1666433fallowing
favoring1596673fa_voring
galloping1356253galloping
galoping1258023ga_loping
hailing113820693hail__ing
halloaing1387033halloaing
halloing121510073hallo_ing
hallooing1366343hallooing
hallowing1676943hallowing
haloing113814133ha_lo_ing
harboring1538263harboring
imploring1445573imploring
jailing153415843jail__ing
laboring112110143la_boring
lairing83715343lai__ring
mailing102923343mail__ing
majoring1836363ma_joring
minoring11311473_minoring
nailing83419963nail__ing
pairing103716733pai__ring
pastoring12310853pastoring
philtring1544173philtring
piloting1139693_piloting
railing83325643rail__ing
razoring1836443ra_zoring
sailing83927373sail__ing
sallowing1357383sallowing
savoring1269483sa_voring
siloing83215503_silo_ing
skijoring2142623skijoring
skioring13237223ski_oring
tabering112211423ta_bering
tableting1236353tableting
tabling103216033tabl__ing
tabooing11186313ta_booing
taborin92210453ta_borin_
taborine102510683ta_borine
taborins103310223ta_borins
tabouring1245723tabouring
tailfin1035693tail_fin_
tailfins1135443tail_fins
tailgating1244913tailgating
tailings93211673tail__ings
tailor63412503tailor___
tailorbird13131183tailorbird
tailored936203tailor_ed
tailors73212393tailor__s
tailspin1043763tailspin_
tailspins1143623tailspins
tailwind1243473tail_wind
tainting93613583tai_nting
talcing103111633ta_l_cing
talcking1567083ta_lcking
talking123815823ta_l_king
tallaging1146503tallaging
tallying12318833ta_llying
tambouring1543803tambouring
tampering1438453tampering
tamponing1445993tamponing
tangoing10177893tango_ing
tapering112112503ta_pering
taring73932283ta___ring
tarring83318303ta__rring
tattering102212323tattering
tattooing1043963tattooing
tiering8315253t_i_ering
tiling73426553t_il__ing
tillering1037883tillering
tilling83522783t_il_ling
tilting83417103t_il_ting
tiring74023093t_i__ring
toileting1036263toileting
toiling83219023toil__ing
trailerings1242943trailerings
trailing92916093trail__ing
trilling92815963tril_ling
tutoring938433t_utoring
twilling12268673twil_ling
vailing113817953vail__ing
vaporing1437653va_poring
visoring1238373_visoring
vizoring2134573_vizoring
wailing113620903wail__ing
wairing113414313wai__ring
waitering13310713waitering
walloping1545593walloping
wallowing1666073wallowing

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411116.42023152.8
3Display Results1111110.0631761.9
 (SQL Overall)1786911116.88925938.6
 
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.