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

49 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
scallopers145404(None) 
scalloper1344451scalloper_
callipers1356492_callipers
gallopers12136322_gallopers
scalloped1444462scallope_d
scallops12297392scallop__s
scalpers123710862sca_l_pers
swallowers1653812swallowers
wallopers14136272_wallopers
allovers1137673__allovers
balloters1157673_balloters
calipers1249443_ca_lipers
callers94221963_call__ers
calliopes1346143_calliope_s
callipees1345303_callipees
calliper1247513_calliper_
calloses10313393_callose_s
callower13159073_callower_
caloyers1337343_ca_loyers
escalloped1542593escallope_d
escallops1343193escallop__s
escalopes1344773esca_lope_s
galloper11137183_galloper_
hallowers15137723_hallowers
salliers83613343s_all_iers
sallower11139503s_allower_
scalers93817263sca_l__ers
scallop11237643scallop___
scalloping1543953scalloping
scallopini1452783scallopini
scallopinis1551843scallopinis
scalpels12345883sca_l_pels
scalper113912923sca_l_per_
scampers143611033sca__mpers
scarpers124712513sca__rpers
scaupers12378173sca__upers
scolloped1443653scollope_d
scollops12235703scollop__s
scoopers124210193sc__oopers
scullers103510483scull__ers
shallops13288323shallop__s
shallower1555673shallower_
slalomers1144553sla_lomers
slopers94213093s___lopers
spallers102910733spall__ers
spillovers1542403spillovers
swallower1554333swallower_
walloper13147113_walloper_
wallowers15127653_wallowers

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 Filter1786911406030.406440125.6
2DLD Change Limit140603496.04623255.5
3Display Results49490.0301633.3
 (SQL Overall)178691496.48227567.3
 
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.