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

117 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
cablers11441671(None) 
cabers105023901cab_ers
cabler104519171cabler_
cables104527551cable_s
cablets114216341cablets
callers94221961callers
fablers124812611fablers
abler75624312_abler_
ables75935542_able_s
amblers115213562amblers
babblers113510352babblers
bailers94221352bailers
balers85626932ba_lers
ballers94421012ballers
bawlers124412732bawlers
caber95126832cab_er_
cable95329912cable__
cabled114819872cable_d
cablet104429462cable_t
cacklers163710702cacklers
cadgers114711992cadgers
cagers95624182ca_gers
cahiers123510672cahiers
cajolers17267132cajolers
calkers134414692calkers
callees94117782callees
caller85125482caller_
callets93821702callets
cambers134017432cambers
camlets114314622camlets
campers134220282campers
cancers114018582cancers
candlers114214102candlers
caners84629192ca_ners
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827722canters
capers105428132ca_pers
capless114312762capless
caplets114914522caplets
cappers134419402cappers
carders104820352carders
careers95218782careers
carers85133952ca_rers
carles85435082carle_s
carless95118492carless
carolers103314172carolers
carpers114521252carpers
carters95327242carters
carvers124817532carvers
casters94729892casters
caters85336492ca_ters
caules85927252caule_s
caulkers14375642caulkers
causers94014782causers
cavers115026832ca_vers
cavilers1348112cavilers
ceilers93912532ceilers
cholers124215192cholers
clabbers14359892clabbers
coalers94419332coalers
cobbers134114752cobbers
cobblers14359592cobblers
cobles104622882coble_s
coilers93619902coilers
coolers93522492coolers
crabbers14358742crabbers
cradlers11309182cradlers
crawlers13309002crawlers
cubers105318342cub_ers
cullers93418842cullers
curlers94218062curlers
cutlers94216992cutlers
cyclers1435872cyclers
dabbers123813212dabbers
dabblers13379362dabblers
enablers10196912enablers
fabler116115812fabler_
fables114921672fable_s
fallers103917992fallers
gabbers124612832gabbers
gabblers134110082gabblers
gables94222332gable_s
gamblers13369732gamblers
gaolers83511562gaolers
garblers113810282garblers
hailers104017262hailers
halers94926912ha_lers
haulers104012442haulers
jabbers183610582jabbers
jailers144114042jailers
labelers10249412labelers
ladlers84613562ladlers
mailers94420332mailers
marblers12319232marblers
maulers94213302maulers
nabbers113710462nabbers
nailers73215892nailers
rabblers123810852rabblers
railers74420662railers
ramblers124010372ramblers
sabers85224732sab_ers
sables85026692sable_s
sailers73822312sailers
scalers93817262sca_lers
stablers103611142stablers
tabers84621572tab_ers
tables84524882table_s
tablets94714372tablets
tailers73720182tailers
talers64628142ta_lers
wabblers15398992wabblers
wailers103916802wailers
walers94824462wa_lers
warblers13319102warblers
yabbers14389352yabbers

Search took 6 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 Filter1786911076710.1231452772.4
2DLD Change Limit1076711174.87622081.8
3Display Results1171170.0462543.5
 (SQL Overall)1786911175.04535419.4
 
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.