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

65 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
equipper214305(None) 
equipped2243071equipped
equippers2242901equippers
quipper2095821_quipper
quipped2175162_quipped
quippers2184812_quippers
quippier2133772_quippier
aquifer1934883aqui_fer
aquiver1934753aqui_ver
chipper163912583_chipper
clipper133710323_clipper
crupper13338563cru_pper
cupper124313863_cu_pper
dipper114017793__dipper
dripper12349233_dripper
eclipser1242793eclipser
encipher1544133encipher
equine151711573equi_ne_
equines161811593equi_nes
equip16467263equi_p__
equipage2043073equipage
equipages2143123equipages
equipment2244843equipment
equipping2342843equipping
equips17387193equi_p_s
equites162212493equi_tes
equities17310773equities
flipper14389143_flipper
gipper114215303__gipper
gripper124410713_gripper
hipper133818023__hipper
kipper143414213__kipper
lipper104219633__lipper
nipper103715713__nipper
quicker2247023_quicker
quieter162810333_quieter
quilter16279803_quilter
quippu19344863_quipp_u
quippus20363543_quippus
quippy22384263_quipp_y
quipster1933933_quipster
quitter162910753_quitter
quiver18278743_qui_ver
quizzer2434393_quizzer
reequipped2451233reequipped
requirer17156113requi_rer
requiter17168643requi_ter
reshipper1643623reshipper
ripper103518653__ripper
scupper1367423scu_pper
shipper143514043_shipper
sipper103920993__sipper
skipper15339573_skipper
slipper113712983_slipper
snipper113911333_snipper
squinter1747363squinter
squirmer1934373squirmer
squirter1746523squirter
stripper1247123stripper
supper104115433_su_pper
tipper103918413__tipper
tripper113711923_tripper
upper93714263__u_pper
whipper173611383_whipper
zipper193813123__zipper

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 Filter1786911461620.423422437.4
2DLD Change Limit146162656.53022383.2
3Display Results65650.0331969.7
 (SQL Overall)178691656.98625578.4
 
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.