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

57 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
equippers224290(None) 
equipper2143051equipper_
quippers2184811_quippers
equipped2243072equippe_d
quipper2095822_quipper_
aquifers2044393aqui_fers
chippers173510883_chippers
clippers14368843_clippers
cruppers14317323cru_ppers
cuppers133712213_cu_ppers
dippers123615183__dippers
drippers13327943_drippers
eclipsers1342643eclipsers
enciphers1644013enciphers
equines161811593equi_ne_s
equipages2143123equipages
equipment2244843equipment
equipments2344023equipments
equipping2342843equipping
equips17387193equi_p__s
equites162212493equi_te_s
equities17310773equitie_s
flippers15338003_flippers
gippers123212083__gippers
grippers13358133_grippers
kippers153211433__kippers
lippers113416443__lippers
nippers113012623__nippers
quieters17248733_quieters
quilters17228433_quilters
quipped2175163_quippe_d
quippier2133773_quippier_
quippus20363543_quipp_us
quipsters2043593_quipsters
quitters17238523_quitters
quivers19298753_qui_vers
quizzers2542943_quizzers
requirers18165003requi_rers
requiters18176553requi_ters
reshippers1742853reshippers
rippers114115033__rippers
scuppers1446543scu_ppers
shippers153012313_shippers
sippers113117753__sippers
skippers16318203_skippers
slippers123711233_slippers
snippers12299723_snippers
squinters1835523squinters
squirmers2053113squirmers
squirters1835073squirters
strippers1355773strippers
suppers113314703_su_ppers
tippers113414353__tippers
trippers123210163_trippers
uppers102912293__u_ppers
whippers18329043_whippers
zippers203310383__zippers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641577.31320325.6
3Display Results57570.0163562.5
 (SQL Overall)178691577.75223051.0
 
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.