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

84 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
yapock17365381yapock
yapocks18354722yapocks
yapok14468152yapo_k
yapoks15346782yapoks
yapon104613582yapo_n
yapons114411772yapons
aboil72217543_aboil
acock132110213_acock
afoul8510193_afoul
apace94718383_apace
apical10913903_apical
apo511142123_apo__
apod78123183_apo_d
apodal9289833_apodal
apods86316343_apods
apollo837183_apollo
aport75432173_aport
apos65433823_apo_s
appal95315223_appal
appel94615893_appel
atoll57913923_atoll
awol75620673_awo_l
babool103012153babool
capful1368183capful
capo85829213capo__
capon95221873capo_n
capons104119503capons
caporal11410943caporal
capos94826073capo_s
capote10315733capote
capouch1644413capouch
caprock1736813caprock
caroch13911763caroch
carol75128613caro_l
carpool1139223carpool
epoch1248203_epoch
gaol56925413ga_o_l
havoc1337183havoc_
havocs1435653havocs
kapok10448783kapo_k
kapoks11347263kapoks
lapel73716683lap_el
lapful1156483lapful
papacy1547493papacy
papal95820673pap_al
parol74826273paro_l
pock126129293__pock
poco86826153__poco
pol56449383__po_l
poll66332133__poll
pool65835953__pool
rappel104211953rappel
repoll8410793repoll
salol55222143salo_l
sapor75119253sapo_r
sapors84118813sapors
sapota8310213sapota
sapote8314363sapote
sapour83812383sapour
spoil75818653_spoil
spool75219043_spool
tapioca1144633tapioca
taroc75721643taroc_
tarocs84615663tarocs
taxol124011363taxo_l
vanpool1243763vanpool
vapor104013093vapo_r
vapors113812693vapors
vapory14398763vapory
vapour11378873vapour
yack135425973ya__ck
yahoo112911543yaho_o
yahoos12209243yahoos
yap85949823yap___
yapped144415143yapped
yapper133714513yapper
yaps95933523yap__s
yaupon11345493yaupo_n
yaupons12345683yaupons
yawl104918973ya__wl
yock135924613y__ock
yowl105820953y__owl
yupon10469483yupo_n
yupons11398353yupons

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 Filter1786911127160.390458182.1
2DLD Change Limit112716847.45315123.6
3Display Results84840.0332545.5
 (SQL Overall)178691847.87622688.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.