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 “warty” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
warty11932382(None) 
arty77531311_arty
party106630611party
swarty125812381swarty
tarty86328181tarty
wart77866081wart_
warts814840401warts
wary106740011war_y
army96624182_army
art38679142_art_
arts49650262_arts
artsy86012962_artsy
awry107619682awr_y
banty106624002banty
barky145721612barky
barmy125218762barmy
barny105821732barny
batty105422242batty
bawty135614102bawty
borty105522832borty
canty105226802canty
carny105822922carny
carry105823782carry
cart66570342cart_
carte75940422carte
carts78946292carts
catty104520412catty
darky136018832darky
dart55857872dart_
darts67635732darts
dirty95617802dirty
dorty96220812dorty
early85324122early
earth85023052earth
earthy12399942earthy
farcy135217092farcy
fart76860562fart_
farts88336842farts
fatty115117412fatty
forty114824272forty
garth94720222garth
hardy125622062hardy
harpy136418202harpy
harry115322952harry
hart76865772hart_
harts88441592harts
hasty115718762hasty
hearty126313632hearty
janty156816962janty
kart86750802kart_
karts97630112karts
laity85318902laity
lardy96119272lardy
larky125218872larky
malty106721702malty
marly106925612marly
marry104821692marry
mart66865972mart_
marts77442232marts
martyr1135692martyr
marvy135014032marvy
narky126017802narky
nary76931222nar_y
nasty85717282nasty
natty85719142natty
panty105929302panty
pardy115523952pardy
parity114719872parity
parry105323752parry
part65967462part_
partly116315472partly
parts77743372parts
pasty105725052pasty
patty104723612patty
paty95234562pa_ty
purty105019402purty
qwerty2133582qwerty
rarity93615492rarity
ratty84819592ratty
salty85524382salty
sarky125521782sarky
smarty115013792smarty
swart86234642swart_
swarth126012082swarth
swarthy16466372swarthy
tardy94720462tardy
tarry85422512tarry
tart47566182tart_
tartly96014022tartly
tarts57242022tarts
tasty84820312tasty
tatty84720182tatty
vary105226062var_y
vasty116215922vasty
wacky174714932wacky
waddy135312992waddy
wady115324992wa_dy
waft106139002waft_
wafts116920552wafts
wait75553692wait_
waits88333522waits
wally114625092wally
waltz17615472waltz
waly105830902wa_ly
waney115120322waney
wanly115118022wanly
want76156162want_
wants87932212wants
wany106432352wa_ny
war67262422war__
ward86542252war_d
wards97734402wards
ware76254722war_e
wared96339872wared
wares88250582wares
warily122915092warily
wark115737772war_k
warks127932402warks
warm95935672war_m
warmly14228062warmly
warms107726852warms
warmth1477932warmth
warn75239322war_n
warns87231002warns
warp95635002war_p
warps107126422warps
wars78659802war_s
warted104223232warted
washy145911842washy
waspy135410992waspy
wast75655852wast_
waste86125052waste
wastry12388772wastry
wasts87433672wasts
wat67378922wa_t_
wats77555882wa_ts
watt75545412wa_tt
watts86923092watts
wavey145115542wavey
wavy136620472wa_vy
waxy175918202wa_xy
way96757662wa__y
weary115620612wear_y
wert79749822wert_
whity145513472whity
wifty144212092wifty
wiry106422832wir_y
witty114717012witty
wordy126916162wordy
wormy137514252wormy
worry116114332worry
wort76654752wort_
worth117120522worth
worthy15598802worthy
worts88631182worts
wrath115715872wrath
wrathy15377852wrathy
wry96524702w_r_y

Search took 3 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 Filter178691538000.1101624463.6
2DLD Change Limit538001582.48621641.2
3Display Results1581580.0931698.9
 (SQL Overall)1786911582.68966452.6
 
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.